APPS.GCS_INTERCO_DYNAMIC_PKG dependencies on FEM_CCTR_ORGS_ATTR

Line 778: fem_cctr_orgs_attr fcoa2 ,

774: SUM(NVL(ytd_credit_balance_e,0)))))
775:
776: FROM GCS_ENTRY_LINES_GT gel,
777: GCS_INTERCO_HDR_GT gihg1,
778: fem_cctr_orgs_attr fcoa2 ,
779: fem_cctr_orgs_attr fcoa3
780: WHERE gihg1.entry_id = gel.entry_id
781: AND gel.receivables_org_id =
782: fcoa2.company_cost_center_org_id

Line 779: fem_cctr_orgs_attr fcoa3

775:
776: FROM GCS_ENTRY_LINES_GT gel,
777: GCS_INTERCO_HDR_GT gihg1,
778: fem_cctr_orgs_attr fcoa2 ,
779: fem_cctr_orgs_attr fcoa3
780: WHERE gihg1.entry_id = gel.entry_id
781: AND gel.receivables_org_id =
782: fcoa2.company_cost_center_org_id
783: AND fcoa2.attribute_id =

Line 1214: fem_cctr_orgs_attr fcoa2,

1210: GCS_ENTITY_CCTR_ORGS geo,
1211: GCS_ENTITY_CCTR_ORGS geo1,
1212: GCS_CONS_RELATIONSHIPS gcr,
1213: GCS_CONS_RELATIONSHIPS gcr1,
1214: fem_cctr_orgs_attr fcoa2,
1215: fem_cctr_orgs_attr fcoa3,
1216: fem_user_dim1_attr fcca
1217: WHERE geh.entry_id IN (p_entry_id, p_stat_entry_id)
1218: AND geh.entry_id = gel.entry_id

Line 1215: fem_cctr_orgs_attr fcoa3,

1211: GCS_ENTITY_CCTR_ORGS geo1,
1212: GCS_CONS_RELATIONSHIPS gcr,
1213: GCS_CONS_RELATIONSHIPS gcr1,
1214: fem_cctr_orgs_attr fcoa2,
1215: fem_cctr_orgs_attr fcoa3,
1216: fem_user_dim1_attr fcca
1217: WHERE geh.entry_id IN (p_entry_id, p_stat_entry_id)
1218: AND geh.entry_id = gel.entry_id
1219: AND gel.intercompany_id <> x_specific_intercompany_id

Line 1357: fem_cctr_orgs_attr fcoa2,

1353: GCS_ENTITY_CCTR_ORGS geo,
1354: GCS_ENTITY_CCTR_ORGS geo1,
1355: GCS_CONS_RELATIONSHIPS gcr,
1356: GCS_CONS_RELATIONSHIPS gcr1,
1357: fem_cctr_orgs_attr fcoa2,
1358: fem_cctr_orgs_attr fcoa3,
1359: fem_user_dim1_attr fcca
1360: WHERE geh.entry_id IN (p_entry_id, p_stat_entry_id)
1361: AND geh.entry_id = gel.entry_id

Line 1358: fem_cctr_orgs_attr fcoa3,

1354: GCS_ENTITY_CCTR_ORGS geo1,
1355: GCS_CONS_RELATIONSHIPS gcr,
1356: GCS_CONS_RELATIONSHIPS gcr1,
1357: fem_cctr_orgs_attr fcoa2,
1358: fem_cctr_orgs_attr fcoa3,
1359: fem_user_dim1_attr fcca
1360: WHERE geh.entry_id IN (p_entry_id, p_stat_entry_id)
1361: AND geh.entry_id = gel.entry_id
1362: AND gel.intercompany_id <> gel.company_cost_center_org_id

Line 1681: fem_cctr_orgs_attr fcoa2,

1677: GCS_ENTITY_CCTR_ORGS geo,
1678: GCS_ENTITY_CCTR_ORGS geo1,
1679: GCS_CONS_RELATIONSHIPS gcr,
1680: GCS_CONS_RELATIONSHIPS gcr1,
1681: fem_cctr_orgs_attr fcoa2,
1682: fem_cctr_orgs_attr fcoa3
1683: WHERE geh.entry_id IN (p_entry_id, p_stat_entry_id)
1684: AND geh.entry_id = gel.entry_id
1685: AND gel.intercompany_id <> x_specific_intercompany_id

Line 1682: fem_cctr_orgs_attr fcoa3

1678: GCS_ENTITY_CCTR_ORGS geo1,
1679: GCS_CONS_RELATIONSHIPS gcr,
1680: GCS_CONS_RELATIONSHIPS gcr1,
1681: fem_cctr_orgs_attr fcoa2,
1682: fem_cctr_orgs_attr fcoa3
1683: WHERE geh.entry_id IN (p_entry_id, p_stat_entry_id)
1684: AND geh.entry_id = gel.entry_id
1685: AND gel.intercompany_id <> x_specific_intercompany_id
1686: AND gel.intercompany_id =

Line 1793: fem_cctr_orgs_attr fcoa2,

1789: GCS_ENTITY_CCTR_ORGS geo,
1790: GCS_ENTITY_CCTR_ORGS geo1,
1791: GCS_CONS_RELATIONSHIPS gcr,
1792: GCS_CONS_RELATIONSHIPS gcr1,
1793: fem_cctr_orgs_attr fcoa2,
1794: fem_cctr_orgs_attr fcoa3
1795: WHERE geh.entry_id IN (p_entry_id, p_stat_entry_id)
1796: AND geh.entry_id = gel.entry_id
1797: AND gel.intercompany_id =

Line 1794: fem_cctr_orgs_attr fcoa3

1790: GCS_ENTITY_CCTR_ORGS geo1,
1791: GCS_CONS_RELATIONSHIPS gcr,
1792: GCS_CONS_RELATIONSHIPS gcr1,
1793: fem_cctr_orgs_attr fcoa2,
1794: fem_cctr_orgs_attr fcoa3
1795: WHERE geh.entry_id IN (p_entry_id, p_stat_entry_id)
1796: AND geh.entry_id = gel.entry_id
1797: AND gel.intercompany_id =
1798: geo.company_cost_center_org_id