eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_AP_PBD_EXPORT_PKG dependencies on JA_CN_CFS_DATA_CLT_PKG

Line 917: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Ael.CODE_COMBINATION_ID) =

913: --BSV condition, to handle one invoice having BSVs from different legal entity in distribution lines
914: AND EXISTS
915: (SELECT llbg.Bal_Seg_Value
916: FROM ja_cn_ledger_le_bsv_gt llbg
917: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Ael.CODE_COMBINATION_ID) =
918: llbg.Bal_Seg_Value
919: AND llbg.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
920: AND llbg.Legal_Entity_Id = pn_legal_entity_id); --parameter: pn_legal_entity_id
921:

Line 1064: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Ael.CODE_COMBINATION_ID) =

1060: --BSV condition, to handle one invoice having BSVs from different legal entity in distribution lines
1061: AND EXISTS
1062: (SELECT llbg.Bal_Seg_Value
1063: FROM ja_cn_ledger_le_bsv_gt llbg
1064: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Ael.CODE_COMBINATION_ID) =
1065: llbg.Bal_Seg_Value
1066: AND llbg.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
1067: AND llbg.Legal_Entity_Id = pn_legal_entity_id); --parameter: pn_legal_entity_id
1068:

Line 1683: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Ael.CODE_COMBINATION_ID) =

1679: --BSV condition, to handle one invoice having BSVs from different legal entity in distribution lines
1680: AND EXISTS
1681: (SELECT llbg.Bal_Seg_Value
1682: FROM ja_cn_ledger_le_bsv_gt llbg
1683: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Ael.CODE_COMBINATION_ID) =
1684: llbg.Bal_Seg_Value
1685: AND llbg.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
1686: AND llbg.Legal_Entity_Id = pn_legal_entity_id); --parameter: pn_legal_entity_id
1687:

Line 1730: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Ael.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value

1726: AND Jeh.Status = 'P' --only collecting posted payment
1727: --BSV condition, to handle one invoice having BSVs from different legal entity in distribution lines
1728: AND EXISTS (SELECT llbg.Bal_Seg_Value
1729: FROM ja_cn_ledger_le_bsv_gt llbg
1730: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Ael.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value
1731: AND llbg.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
1732: AND llbg.Legal_Entity_Id = pn_legal_entity_id) --parameter: pn_legal_entity_id*/
1733: SELECT SUM(NVL(Aip.Amount, 0)) Paid_Amount
1734: FROM Ap_Invoices_All Aia, Ap_Invoice_Payments_All Aip

Line 1814: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Ael.CODE_COMBINATION_ID) =

1810: --BSV condition, to handle one invoice having BSVs from different legal entity in distribution lines
1811: AND EXISTS
1812: (SELECT llbg.Bal_Seg_Value
1813: FROM ja_cn_ledger_le_bsv_gt llbg
1814: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Ael.CODE_COMBINATION_ID) =
1815: llbg.Bal_Seg_Value
1816: AND llbg.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
1817: AND llbg.Legal_Entity_Id = pn_legal_entity_id) --parameter: pn_legal_entity_id
1818: );

Line 1916: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Ael.CODE_COMBINATION_ID) =

1912: --BSV condition, to handle one invoice having BSVs from different legal entity in distribution lines
1913: AND EXISTS
1914: (SELECT llbg.Bal_Seg_Value
1915: FROM ja_cn_ledger_le_bsv_gt llbg
1916: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Ael.CODE_COMBINATION_ID) =
1917: llbg.Bal_Seg_Value
1918: AND llbg.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
1919: AND llbg.Legal_Entity_Id = pn_legal_entity_id); --parameter: pn_legal_entity_id
1920:

Line 1957: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Ael.CODE_COMBINATION_ID) =

1953: --BSV condition, to handle one invoice having BSVs from different legal entity in distribution lines
1954: AND EXISTS
1955: (SELECT llbg.Bal_Seg_Value
1956: FROM ja_cn_ledger_le_bsv_gt llbg
1957: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Ael.CODE_COMBINATION_ID) =
1958: llbg.Bal_Seg_Value
1959: AND llbg.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
1960: AND llbg.Legal_Entity_Id = pn_legal_entity_id); --parameter: pn_legal_entity_id
1961:

Line 2055: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Ael.CODE_COMBINATION_ID) =

2051: --BSV condition, to handle one invoice having BSVs from different legal entity in distribution lines
2052: AND EXISTS
2053: (SELECT llbg.Bal_Seg_Value
2054: FROM ja_cn_ledger_le_bsv_gt llbg
2055: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Ael.CODE_COMBINATION_ID) =
2056: llbg.Bal_Seg_Value
2057: AND llbg.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
2058: AND llbg.Legal_Entity_Id = pn_legal_entity_id) --parameter: pn_legal_entity_id
2059: )

Line 2288: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Jcc.CODE_COMBINATION_ID) =

2284: --BSV condition
2285: AND EXISTS
2286: (SELECT llbg.Bal_Seg_Value
2287: FROM ja_cn_ledger_le_bsv_gt llbg
2288: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Jcc.CODE_COMBINATION_ID) =
2289: llbg.Bal_Seg_Value
2290: AND llbg.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
2291: AND llbg.Legal_Entity_Id = pn_legal_entity_id); --parameter: pn_legal_entity_id
2292:

Line 2696: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Jcc.CODE_COMBINATION_ID) =

2692: AND NVL(Sup.Vendor_Type_Lookup_Code, 'CUSTOMER') <> 'EMPLOYEE' --not considering employee supplier
2693: --BSV condition
2694: AND EXISTS (SELECT llbg.Bal_Seg_Value
2695: FROM ja_cn_ledger_le_bsv_gt llbg
2696: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Jcc.CODE_COMBINATION_ID) =
2697: llbg.Bal_Seg_Value
2698: AND llbg.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
2699: AND llbg.Legal_Entity_Id = pn_legal_entity_id) --parameter: pn_legal_entity_id
2700: AND Fcv.CURRENCY_CODE = Gl.Currency_Code