eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_AUTOSOURCE_SV dependencies on PO_ASL_STATUS_RULES_V

Line 704: Added the table PO_ASL_STATUS_RULES_V and corresponding where condition

700: -- fetches the UOM from the local attributes record before the
701: -- the global.
702:
703: /* Bug # 1671405. pchintal
704: Added the table PO_ASL_STATUS_RULES_V and corresponding where condition
705: to the below cursor so that it will not fetch those asl_id's whose
706: status has a control value of PREVENT and rule is SOURCING, so that
707: the ASL with status debarred will not be picked and sourcing will happen
708: properly.

Line 728: po_asl_status_rules_v pasr

724: paa.enable_vmi_auto_replenish_flag,
725: paa.vmi_replenishment_approval
726: FROM po_approved_supplier_lis_val_v pasl,
727: po_asl_attributes paa,
728: po_asl_status_rules_v pasr
729: WHERE pasl.item_id = x_item_id --
730: AND pasl.vendor_id = x_vendor_id
731: AND (nvl(pasl.vendor_site_id, -1) = nvl(x_vendor_site_id, -1)
732: OR pasl.vendor_site_id IS NULL) --Bug #13743965

Line 769: po_asl_status_rules_v pasr

765: paa.enable_vmi_auto_replenish_flag,
766: paa.vmi_replenishment_approval
767: FROM po_approved_supplier_lis_val_v pasl,
768: po_asl_attributes paa,
769: po_asl_status_rules_v pasr
770: WHERE pasl.category_id = p_category_id --
771: AND pasl.vendor_id = x_vendor_id
772: AND (nvl(pasl.vendor_site_id, -1) = nvl(x_vendor_site_id, -1)
773: OR pasl.vendor_site_id IS NULL) --Bug #13743965

Line 3822: --SQL JOIN: po_asl_attributes using asl_id, po_asl_status_rules_v using status_id

3818: )
3819: IS
3820: --SQL WHAT: Get the matching asl_id if one exists in current OU
3821: --SQL WHY: This information will be used to identify the document in ASL.
3822: --SQL JOIN: po_asl_attributes using asl_id, po_asl_status_rules_v using status_id
3823: -- po_vendor_sites_all using vendor_site_id
3824: SELECT pasl.asl_id, paa.using_organization_id,
3825: pasl.primary_vendor_item, paa.purchasing_unit_of_measure,
3826: paa.consigned_from_supplier_flag, paa.enable_vmi_flag

Line 3829: po_asl_status_rules_v pasr,

3825: pasl.primary_vendor_item, paa.purchasing_unit_of_measure,
3826: paa.consigned_from_supplier_flag, paa.enable_vmi_flag
3827: FROM po_approved_supplier_lis_val_v pasl,
3828: po_asl_attributes paa,
3829: po_asl_status_rules_v pasr,
3830: po_vendor_sites_all pvs
3831: WHERE pasl.item_id = p_item_id --
3832: AND pasl.vendor_id = p_vendor_id
3833: AND pasl.using_organization_id in (-1, p_using_organization_id) --

Line 3861: --SQL JOIN: po_asl_attributes using asl_id, po_asl_status_rules_v using status_id

3857: )
3858: IS
3859: --SQL WHAT: Get the matching asl_id, sequence_num of GA if one exists in other OU
3860: --SQL WHY: This information will be used to identify the document in ASL.
3861: --SQL JOIN: po_asl_attributes using asl_id, po_asl_status_rules_v using status_id
3862: -- po_asl_docuyment using asl_id, sequence_num, po_headers_all using
3863: -- po_header_id, po_lines_all using po_line_id
3864: SELECT pasl.asl_id, paa.using_organization_id,
3865: pasl.primary_vendor_item, paa.purchasing_unit_of_measure,

Line 3870: po_asl_status_rules_v pasr,

3866: paa.consigned_from_supplier_flag, paa.enable_vmi_flag,
3867: pad.sequence_num
3868: FROM po_approved_supplier_lis_val_v pasl,
3869: po_asl_attributes paa,
3870: po_asl_status_rules_v pasr,
3871: po_asl_documents pad,
3872: po_headers_all poh,
3873: po_lines_all pol
3874: WHERE pasl.item_id = p_item_id --

Line 4197: --SQL JOIN: po_asl_attributes using asl_id, po_asl_status_rules_v using status_id

4193: )
4194: IS
4195: --SQL WHAT: Get the matching asl_id if one exists in current OU
4196: --SQL WHY: This information will be used to identify the document in ASL.
4197: --SQL JOIN: po_asl_attributes using asl_id, po_asl_status_rules_v using status_id
4198: -- po_vendor_sites_all using vendor_site_id
4199: SELECT pasl.asl_id, paa.using_organization_id,
4200: pasl.primary_vendor_item, paa.purchasing_unit_of_measure,
4201: paa.consigned_from_supplier_flag, paa.enable_vmi_flag

Line 4204: po_asl_status_rules_v pasr,

4200: pasl.primary_vendor_item, paa.purchasing_unit_of_measure,
4201: paa.consigned_from_supplier_flag, paa.enable_vmi_flag
4202: FROM po_approved_supplier_lis_val_v pasl,
4203: po_asl_attributes paa,
4204: po_asl_status_rules_v pasr,
4205: po_vendor_sites_all pvs
4206: WHERE pasl.category_id = p_category_id --
4207: AND pasl.vendor_id = p_vendor_id
4208: AND pasl.using_organization_id in (-1, p_using_organization_id) --

Line 4234: --SQL JOIN: po_asl_attributes using asl_id, po_asl_status_rules_v using status_id

4230: )
4231: IS
4232: --SQL WHAT: Get the matching asl_id, sequence_num of GA if one exists in other OU
4233: --SQL WHY: This information will be used to identify the document in ASL.
4234: --SQL JOIN: po_asl_attributes using asl_id, po_asl_status_rules_v using status_id
4235: -- po_asl_docuyment using asl_id, sequence_num, po_headers_all using
4236: -- po_header_id, po_lines_all using po_line_id
4237: SELECT pasl.asl_id, paa.using_organization_id,
4238: pasl.primary_vendor_item, paa.purchasing_unit_of_measure,

Line 4243: po_asl_status_rules_v pasr,

4239: paa.consigned_from_supplier_flag, paa.enable_vmi_flag,
4240: pad.sequence_num
4241: FROM po_approved_supplier_lis_val_v pasl,
4242: po_asl_attributes paa,
4243: po_asl_status_rules_v pasr,
4244: po_asl_documents pad,
4245: po_headers_all poh,
4246: po_lines_all pol
4247: WHERE pasl.category_id = p_category_id --

Line 5561: po_asl_status_rules_v pasr

5557: pasl.primary_vendor_item,
5558: paa.purchasing_unit_of_measure
5559: FROM po_approved_supplier_lis_val_v pasl,
5560: po_asl_attributes paa,
5561: po_asl_status_rules_v pasr
5562: WHERE pasl.item_id = x_item_id
5563: AND (pasl.using_organization_id IN
5564: (-1, x_using_organization_id))
5565: AND pasl.asl_id = paa.asl_id