APPS.INV_INVTRDST_XMLP_PKG dependencies on MTL_CYCLE_COUNT_HEADERS

Line 511: RETURN ('mtl_cycle_count_headers cch,');

507: IF P_SOURCE_TYPE_ID = 7 AND (P_SOURCE_HI IS NOT NULL OR P_SOURCE_LO IS NOT NULL) THEN
508: RETURN ('po_requisition_headers prh,');
509: END IF;
510: IF P_SOURCE_TYPE_ID = 9 AND (P_SOURCE_HI IS NOT NULL OR P_SOURCE_LO IS NOT NULL) THEN
511: RETURN ('mtl_cycle_count_headers cch,');
512: END IF;
513: IF P_SOURCE_TYPE_ID = 10 AND (P_SOURCE_HI IS NOT NULL OR P_SOURCE_LO IS NOT NULL) THEN
514: RETURN ('mtl_physical_inventories pi,');
515: END IF;

Line 868: from mtl_cycle_count_headers

864: txn_source_id;
865: return(txn_source);
866: elsif Type_id = 9 then
867: select CYCLE_COUNT_HEADER_NAME into txn_source
868: from mtl_cycle_count_headers
869: where cycle_count_header_id = to_number(txn_source_id)
870: and organization_id = org_id;
871: return(txn_source);
872: elsif Type_id = 10 then

Line 947: from mtl_cycle_count_headers

943: txn_source_id;
944: return(txn_source);
945: elsif Type_id1 = 9 then
946: select CYCLE_COUNT_HEADER_NAME into txn_source
947: from mtl_cycle_count_headers
948: where cycle_count_header_id = to_number(txn_source_id)
949: and organization_id = org_id;
950: return(txn_source);
951: elsif Type_id1 = 10 then

Line 1026: from mtl_cycle_count_headers

1022: txn_source_id;
1023: return(txn_source);
1024: elsif Type_id2 = 9 then
1025: select CYCLE_COUNT_HEADER_NAME into txn_source
1026: from mtl_cycle_count_headers
1027: where cycle_count_header_id = to_number(txn_source_id)
1028: and organization_id = org_id;
1029: return(txn_source);
1030: elsif Type_id2 = 10 then

Line 1105: from mtl_cycle_count_headers

1101: txn_source_id;
1102: return(txn_source);
1103: elsif Type_id3 = 9 then
1104: select CYCLE_COUNT_HEADER_NAME into txn_source
1105: from mtl_cycle_count_headers
1106: where cycle_count_header_id = to_number(txn_source_id)
1107: and organization_id = org_id;
1108: return(txn_source);
1109: elsif Type_id3 = 10 then

Line 1184: from mtl_cycle_count_headers

1180: txn_source_id;
1181: return(txn_source);
1182: elsif Type_id4 = 9 then
1183: select CYCLE_COUNT_HEADER_NAME into txn_source
1184: from mtl_cycle_count_headers
1185: where cycle_count_header_id = to_number(txn_source_id)
1186: and organization_id = org_id;
1187: return(txn_source);
1188: elsif Type_id4 = 10 then