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_LEDGER_LE_BSV_GT

Line 916: FROM ja_cn_ledger_le_bsv_gt llbg

912: pn_ae_header_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

Line 1063: FROM ja_cn_ledger_le_bsv_gt llbg

1059: AND Jcc.Ledger_Id = pn_ledger_id --parameter: pn_ledger_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

Line 1682: FROM ja_cn_ledger_le_bsv_gt llbg

1678: AND Aeh.Ae_Header_Id = Ael.Ae_Header_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

Line 1729: FROM ja_cn_ledger_le_bsv_gt llbg

1725: AND Gir.Je_Header_Id = Jeh.Je_Header_Id
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

Line 1813: FROM ja_cn_ledger_le_bsv_gt llbg

1809: AND Gp.period_name = pv_period_name) --parameter: pv_period_name
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

Line 1915: FROM ja_cn_ledger_le_bsv_gt llbg

1911: AND Aeh.Ae_Header_Id = Ael.Ae_Header_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

Line 1956: FROM ja_cn_ledger_le_bsv_gt llbg

1952: AND Gp.period_name = pv_period_name) --parameter: pv_period_name
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

Line 2054: FROM ja_cn_ledger_le_bsv_gt llbg

2050: AND Jcc.Code_Combination_Id = 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

Line 2287: FROM ja_cn_ledger_le_bsv_gt llbg

2283: AND NVL(Sup.Vendor_Type_Lookup_Code, 'CUSTOMER') <> 'EMPLOYEE' --not considering employee supplier
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

Line 2695: FROM ja_cn_ledger_le_bsv_gt llbg

2691: AND Ael.Accounting_Class_Code = 'LIABILITY' --only collecting 'Liability' account
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