APPS.INVKBCGN dependencies on MTL_PULL_SEQ_SUPPLIERS

Line 496: ' exists ( select 1 from mtl_pull_seq_suppliers mpss ' ||

492: ' nvl(mkps.subinventory_name,''9999'') = ' ||
493: ' nvl(:subinv, nvl(mkps.subinventory_name,''9999'')) AND ' ||
494: ' nvl(mkps.source_type,-9999) = nvl(:source_type,nvl(mkps.source_type,-9999)) AND '||
495: ' ( :supplier_id is null or (:supplier_id is not null and ' ||
496: ' exists ( select 1 from mtl_pull_seq_suppliers mpss ' ||
497: ' where mpss.organization_id = mkps.organization_id ' ||
498: ' and mpss.pull_sequence_id = mkps.pull_sequence_id ' ||
499: ' and mpss.supplier_id = :supplier_id ' ||
500: ' and rownum = 1 ' ||

Line 505: ' exists( select 1 from mtl_pull_seq_suppliers mpss ' ||

501: ' ) ' ||
502: ' ) ' ||
503: ' ) AND ' ||
504: ' ( :supplier_site_id is null or (:supplier_site_id is not null and ' ||
505: ' exists( select 1 from mtl_pull_seq_suppliers mpss ' ||
506: ' where mpss.organization_id = mkps.organization_id ' ||
507: ' and mpss.pull_sequence_id = mkps.pull_sequence_id ' ||
508: ' and mpss.supplier_id = :supplier_id ' ||
509: ' and mpss.supplier_site_id = :supplier_site_id ' ||

Line 685: ' exists ( select 1 from mtl_pull_seq_suppliers mpss ' ||

681: ' nvl(mkps.subinventory_name,''9999'') = ' ||
682: ' nvl(:subinv, nvl(mkps.subinventory_name,''9999'')) AND ' ||
683: ' nvl(mkps.source_type,-9999) = nvl(:source_type,nvl(mkps.source_type,-9999)) AND '||
684: ' ( :supplier_id is null or (:supplier_id is not null and ' ||
685: ' exists ( select 1 from mtl_pull_seq_suppliers mpss ' ||
686: ' where mpss.organization_id = mkps.organization_id ' ||
687: ' and mpss.pull_sequence_id = mkps.pull_sequence_id ' ||
688: ' and mpss.supplier_id = :supplier_id ' ||
689: ' and rownum = 1 ' ||

Line 694: ' exists( select 1 from mtl_pull_seq_suppliers mpss ' ||

690: ' ) ' ||
691: ' ) ' ||
692: ' ) AND ' ||
693: ' ( :supplier_site_id is null or (:supplier_site_id is not null and ' ||
694: ' exists( select 1 from mtl_pull_seq_suppliers mpss ' ||
695: ' where mpss.organization_id = mkps.organization_id ' ||
696: ' and mpss.pull_sequence_id = mkps.pull_sequence_id ' ||
697: ' and mpss.supplier_id = :supplier_id ' ||
698: ' and mpss.supplier_site_id = :supplier_site_id ' ||

Line 950: exists ( select 1 from mtl_pull_seq_suppliers mpss

946: where mkps.organization_id = X_org_id AND
947: nvl(mkps.subinventory_name,'9999') = nvl(X_subinv, nvl(mkps.subinventory_name,'9999')) AND
948: nvl(mkps.source_type,-9999) = nvl(X_source_type, nvl(mkps.source_type,-9999)) AND
949: ( X_supplier_id is null or (X_supplier_id is not null and
950: exists ( select 1 from mtl_pull_seq_suppliers mpss
951: where mpss.organization_id = mkps.organization_id
952: and mpss.pull_sequence_id = mkps.pull_sequence_id
953: and mpss.supplier_id = X_supplier_id
954: and rownum = 1

Line 959: exists( select 1 from mtl_pull_seq_suppliers mpss

955: )
956: )
957: ) AND
958: ( X_supplier_site_id is null or (X_supplier_site_id is not null and
959: exists( select 1 from mtl_pull_seq_suppliers mpss
960: where mpss.organization_id = mkps.organization_id
961: and mpss.pull_sequence_id = mkps.pull_sequence_id
962: and mpss.supplier_id = X_supplier_id
963: and mpss.supplier_site_id = X_supplier_site_id

Line 1084: ' exists ( select 1 from mtl_pull_seq_suppliers mpss ' ||

1080: ' nvl(mkps.subinventory_name,''9999'') = ' ||
1081: ' nvl(:subinv, nvl(mkps.subinventory_name,''9999'')) AND ' ||
1082: ' nvl(mkps.source_type,-9999) = nvl(:source_type,nvl(mkps.source_type,-9999)) AND '||
1083: ' ( :supplier_id is null or (:supplier_id is not null and ' ||
1084: ' exists ( select 1 from mtl_pull_seq_suppliers mpss ' ||
1085: ' where mpss.organization_id = mkps.organization_id ' ||
1086: ' and mpss.pull_sequence_id = mkps.pull_sequence_id ' ||
1087: ' and mpss.supplier_id = :supplier_id ' ||
1088: ' and rownum = 1 ' ||

Line 1093: ' exists( select 1 from mtl_pull_seq_suppliers mpss ' ||

1089: ' ) ' ||
1090: ' ) ' ||
1091: ' ) AND ' ||
1092: ' ( :supplier_site_id is null or (:supplier_site_id is not null and ' ||
1093: ' exists( select 1 from mtl_pull_seq_suppliers mpss ' ||
1094: ' where mpss.organization_id = mkps.organization_id ' ||
1095: ' and mpss.pull_sequence_id = mkps.pull_sequence_id ' ||
1096: ' and mpss.supplier_id = :supplier_id ' ||
1097: ' and mpss.supplier_site_id = :supplier_site_id ' ||