APPS.GHG_TRANSACTIONS_API_PKG dependencies on GHG_ORGANIZATIONS_D_TMP

Line 1308: write_to_log('Inserting into GHG_ORGANIZATIONS_D_TMP');

1304: write_to_log(substr(SQLERRM, 1, 200));
1305: end;
1306:
1307:
1308: write_to_log('Inserting into GHG_ORGANIZATIONS_D_TMP');
1309: INSERT INTO GHG_ORGANIZATIONS_D_TMP
1310: ( SOURCE_APPLICATION_CODE,
1311: ORGANIZATION_ID,
1312: ORGANIZATION_EXTERNAL_ID,

Line 1309: INSERT INTO GHG_ORGANIZATIONS_D_TMP

1305: end;
1306:
1307:
1308: write_to_log('Inserting into GHG_ORGANIZATIONS_D_TMP');
1309: INSERT INTO GHG_ORGANIZATIONS_D_TMP
1310: ( SOURCE_APPLICATION_CODE,
1311: ORGANIZATION_ID,
1312: ORGANIZATION_EXTERNAL_ID,
1313: ORGANIZATION_CODE,

Line 1437: 'from GHG_ORGANIZATIONS_D_TMP WHERE SOURCE_APPLICATION_CODE='|| p_org_id ||'';

1433: 'ADDRESS_POSTCODE, ' ||
1434: 'ADDRESS_LATITUDE, ' ||
1435: 'address_longitude, ' ||
1436: 'ADDRESS_LOCATION ' ||
1437: 'from GHG_ORGANIZATIONS_D_TMP WHERE SOURCE_APPLICATION_CODE='|| p_org_id ||'';
1438:
1439:
1440: EXECUTE IMMEDIATE v_stmt;
1441:

Line 1480: 'from GHG_ORGANIZATIONS_D_TMP org ' ||

1476: 'ORGANIZATION_id, ' ||
1477: 'ORGANIZATION_id, ' ||
1478: 'ORGANIZATION_id, ' ||
1479: '''N'' ' ||
1480: 'from GHG_ORGANIZATIONS_D_TMP org ' ||
1481: 'where not exists (select 1 ' ||
1482: 'from GHG_ORG_HIERARCHY_STRUCTURES_D@' || v_dblink || ' st ' ||
1483: 'where org.ORGANIZATION_id = st.ORGANIZATION_id) AND SOURCE_APPLICATION_CODE='|| p_org_id ||'';
1484:

Line 1580: ', (select address_state from GHG_ORGANIZATIONS_D_TMP org where org.ORGANIZATION_id = tr.ghg_organization_id) location_state ' ||

1576: ', tr.ghg_asset_id asset_id ' ||
1577: ', tr.vendor_id supplier_id ' ||
1578: ', tr.inventory_item_id item_id ' ||
1579: ', ''A'' actual_or_estimate ' ||
1580: ', (select address_state from GHG_ORGANIZATIONS_D_TMP org where org.ORGANIZATION_id = tr.ghg_organization_id) location_state ' ||
1581: ', (select address_country from GHG_ORGANIZATIONS_D_TMP org where org.ORGANIZATION_id = tr.ghg_organization_id) location_county ' ||
1582: ', tr.ghg_organization_id ORGANIZATION_id ' ||
1583: ', tr.measurement_criteria measurement_criteria_code ' ||
1584: ', tr.measurement_criteria measurement_criteria_desc ' ||

Line 1581: ', (select address_country from GHG_ORGANIZATIONS_D_TMP org where org.ORGANIZATION_id = tr.ghg_organization_id) location_county ' ||

1577: ', tr.vendor_id supplier_id ' ||
1578: ', tr.inventory_item_id item_id ' ||
1579: ', ''A'' actual_or_estimate ' ||
1580: ', (select address_state from GHG_ORGANIZATIONS_D_TMP org where org.ORGANIZATION_id = tr.ghg_organization_id) location_state ' ||
1581: ', (select address_country from GHG_ORGANIZATIONS_D_TMP org where org.ORGANIZATION_id = tr.ghg_organization_id) location_county ' ||
1582: ', tr.ghg_organization_id ORGANIZATION_id ' ||
1583: ', tr.measurement_criteria measurement_criteria_code ' ||
1584: ', tr.measurement_criteria measurement_criteria_desc ' ||
1585: ', nvl(tr.usage_quantity,0) ' ||

Line 1849: ', GHG_ORGANIZATIONS_D_TMP b ' ||

1845: 'b.address_county, ' ||
1846: 'b.address_country, ' ||
1847: 'b.ADDRESS_POSTCODE ' ||
1848: 'from GHG_INTERESTED_PARTIES_ALL a ' ||
1849: ', GHG_ORGANIZATIONS_D_TMP b ' ||
1850: 'where org_id = source_application_code ' ||
1851: 'and a.CONTROLLING_ORGANIZATION_ID = b.ORGANIZATION_code ' ||
1852: ' and a.operational_control <> ''OPC''';
1853: IF p_org_id IS NOT NULL THEN

Line 1914: ', GHG_ORGANIZATIONS_D_TMP b ' ||

1910: 'b.address_county, ' ||
1911: 'b.address_country, ' ||
1912: 'b.ADDRESS_POSTCODE ' ||
1913: 'from GHG_INTERESTED_PARTIES_ALL a ' ||
1914: ', GHG_ORGANIZATIONS_D_TMP b ' ||
1915: 'where org_id = source_application_code ' ||
1916: 'and a.CONTROLLING_ORGANIZATION_ID = b.ORGANIZATION_code ' ||
1917: 'and a.operational_control = ''OPC''';
1918: IF p_org_id IS NOT NULL THEN