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 784: from mtl_cycle_count_headers

780: txn_source_id;
781: return(txn_source);
782: elsif Type_id = 9 then
783: select CYCLE_COUNT_HEADER_NAME into txn_source
784: from mtl_cycle_count_headers
785: where cycle_count_header_id = to_number(txn_source_id)
786: and organization_id = org_id;
787: return(txn_source);
788: elsif Type_id = 10 then

Line 863: from mtl_cycle_count_headers

859: txn_source_id;
860: return(txn_source);
861: elsif Type_id1 = 9 then
862: select CYCLE_COUNT_HEADER_NAME into txn_source
863: from mtl_cycle_count_headers
864: where cycle_count_header_id = to_number(txn_source_id)
865: and organization_id = org_id;
866: return(txn_source);
867: elsif Type_id1 = 10 then

Line 942: from mtl_cycle_count_headers

938: txn_source_id;
939: return(txn_source);
940: elsif Type_id2 = 9 then
941: select CYCLE_COUNT_HEADER_NAME into txn_source
942: from mtl_cycle_count_headers
943: where cycle_count_header_id = to_number(txn_source_id)
944: and organization_id = org_id;
945: return(txn_source);
946: elsif Type_id2 = 10 then

Line 1021: from mtl_cycle_count_headers

1017: txn_source_id;
1018: return(txn_source);
1019: elsif Type_id3 = 9 then
1020: select CYCLE_COUNT_HEADER_NAME into txn_source
1021: from mtl_cycle_count_headers
1022: where cycle_count_header_id = to_number(txn_source_id)
1023: and organization_id = org_id;
1024: return(txn_source);
1025: elsif Type_id3 = 10 then

Line 1100: from mtl_cycle_count_headers

1096: txn_source_id;
1097: return(txn_source);
1098: elsif Type_id4 = 9 then
1099: select CYCLE_COUNT_HEADER_NAME into txn_source
1100: from mtl_cycle_count_headers
1101: where cycle_count_header_id = to_number(txn_source_id)
1102: and organization_id = org_id;
1103: return(txn_source);
1104: elsif Type_id4 = 10 then