获取ccid
FND_FLEX_EXT.GET_COMBINATION_ID
获取科目组合(不同法人,科目组合可能不同,使用api不用考虑各个段的组合)
Fnd_Flex_Ext.Get_Segs(Application_Short_Name => 'SQLGL'
, -- IN VARCHAR2,
Key_Flex_Code => 'GL#'
, -- IN VARCHAR2,
Structure_Number => Gsb.Chart_Of_Accounts_Id
, -- IN NUMBER, -- CHART_OF_ACCOUNT_ID
Combination_Id => Pvsa.Accts_Pay_Code_Combination_Id -- IN NUMBER -- code_Combination_id
)
例子
SELECT Fnd_Flex_Ext.Get_Segs(Application_Short_Name => 'SQLGL'
, -- IN VARCHAR2,
Key_Flex_Code => 'GL#'
, -- IN VARCHAR2,
Structure_Number => Gsb.Chart_Of_Accounts_Id
, -- IN NUMBER, -- CHART_OF_ACCOUNT_ID
Combination_Id => Pvsa.Accts_Pay_Code_Combination_Id -- IN NUMBER -- code_Combination_id
)
,Pvsa.*
FROM Po_Vendor_Sites_All Pvsa
,Hr_Operating_Units Hou
,Gl_Sets_Of_Books Gsb
WHERE Pvsa.Org_Id = Hou.Organization_Id
AND Hou.Set_Of_Books_Id = Gsb.Set_Of_Books_Id;