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_THIRD_PARTY_STOCK_GRP dependencies on PO_ASL_ATTRIBUTES

Line 745: po_asl_attributes paa

741: ( SELECT 'X'
742: FROM po_approved_supplier_list pasl,
743: po_vendor_sites pvs ,
744: po_asl_status_rules_v pasr ,
745: po_asl_attributes paa
746: WHERE pasl.vendor_site_id = pvs.vendor_site_id
747: AND pasr.status_id = pasl.asl_status_id
748: AND pasr.business_rule like '2_SOURCING'
749: AND pasr.allow_action_flag like 'Y'

Line 1130: PO_ASL_ATTRIBUTES.PURCHASING_UNIT_OF_MEASURE%TYPE := NULL;

1126: l_asl_id NUMBER := NULL;
1127: l_vendor_product_num
1128: PO_APPROVED_SUPPLIER_LIS_VAL_V.PRIMARY_VENDOR_ITEM%TYPE := NULL;
1129: l_purchasing_uom
1130: PO_ASL_ATTRIBUTES.PURCHASING_UNIT_OF_MEASURE%TYPE := NULL;
1131: l_using_organization_id NUMBER
1132: := p_using_organization_id;
1133: l_vmi_min_qty NUMBER := NULL;
1134: l_vmi_max_qty NUMBER := NULL;

Line 1136: PO_ASL_ATTRIBUTES.ENABLE_VMI_AUTO_REPLENISH_FLAG%TYPE := NULL;

1132: := p_using_organization_id;
1133: l_vmi_min_qty NUMBER := NULL;
1134: l_vmi_max_qty NUMBER := NULL;
1135: l_vmi_auto_replenish_flag
1136: PO_ASL_ATTRIBUTES.ENABLE_VMI_AUTO_REPLENISH_FLAG%TYPE := NULL;
1137: l_vmi_replenishment_approval
1138: PO_ASL_ATTRIBUTES.VMI_REPLENISHMENT_APPROVAL%TYPE := NULL;
1139:
1140: BEGIN

Line 1138: PO_ASL_ATTRIBUTES.VMI_REPLENISHMENT_APPROVAL%TYPE := NULL;

1134: l_vmi_max_qty NUMBER := NULL;
1135: l_vmi_auto_replenish_flag
1136: PO_ASL_ATTRIBUTES.ENABLE_VMI_AUTO_REPLENISH_FLAG%TYPE := NULL;
1137: l_vmi_replenishment_approval
1138: PO_ASL_ATTRIBUTES.VMI_REPLENISHMENT_APPROVAL%TYPE := NULL;
1139:
1140: BEGIN
1141:
1142: IF (g_fnd_debug = 'Y')

Line 1439: PO_ASL_ATTRIBUTES.CONSIGNED_FROM_SUPPLIER_FLAG%TYPE := NULL;

1435: l_ship_to_organization_id NUMBER := NULL;
1436: l_consigned_flag
1437: PO_LINE_LOCATIONS.CONSIGNED_FLAG%TYPE := NULL;
1438: l_consigned_from_supplier_flag
1439: PO_ASL_ATTRIBUTES.CONSIGNED_FROM_SUPPLIER_FLAG%TYPE := NULL;
1440: l_enable_vmi_flag
1441: PO_ASL_ATTRIBUTES.ENABLE_VMI_FLAG%TYPE := NULL;
1442: l_last_billing_date DATE := NULL;
1443: l_consigned_billing_cycle NUMBER := NULL;

Line 1441: PO_ASL_ATTRIBUTES.ENABLE_VMI_FLAG%TYPE := NULL;

1437: PO_LINE_LOCATIONS.CONSIGNED_FLAG%TYPE := NULL;
1438: l_consigned_from_supplier_flag
1439: PO_ASL_ATTRIBUTES.CONSIGNED_FROM_SUPPLIER_FLAG%TYPE := NULL;
1440: l_enable_vmi_flag
1441: PO_ASL_ATTRIBUTES.ENABLE_VMI_FLAG%TYPE := NULL;
1442: l_last_billing_date DATE := NULL;
1443: l_consigned_billing_cycle NUMBER := NULL;
1444:
1445: CURSOR C is

Line 1611: l_consigned_flag PO_ASL_ATTRIBUTES.consigned_from_supplier_flag%TYPE;

1607: IS
1608: d_mod CONSTANT VARCHAR2(100) := D_get_consigned_flag;
1609: d_position NUMBER := 0;
1610:
1611: l_consigned_flag PO_ASL_ATTRIBUTES.consigned_from_supplier_flag%TYPE;
1612: l_msg_data VARCHAR2(2000);
1613: l_return_status VARCHAR2(1);
1614: l_msg_count NUMBER;
1615: l_asset_flag MTL_SYSTEM_ITEMS_B.inventory_asset_flag%TYPE;

Line 1616: l_enable_vmi_flag PO_ASL_ATTRIBUTES.enable_vmi_flag%TYPE;

1612: l_msg_data VARCHAR2(2000);
1613: l_return_status VARCHAR2(1);
1614: l_msg_count NUMBER;
1615: l_asset_flag MTL_SYSTEM_ITEMS_B.inventory_asset_flag%TYPE;
1616: l_enable_vmi_flag PO_ASL_ATTRIBUTES.enable_vmi_flag%TYPE;
1617: l_last_billing_date PO_ASL_ATTRIBUTES.last_billing_date%TYPE;
1618: l_cons_billing_cycle PO_ASL_ATTRIBUTES.consigned_billing_cycle%TYPE;
1619: --
1620: l_inventory_org_id

Line 1617: l_last_billing_date PO_ASL_ATTRIBUTES.last_billing_date%TYPE;

1613: l_return_status VARCHAR2(1);
1614: l_msg_count NUMBER;
1615: l_asset_flag MTL_SYSTEM_ITEMS_B.inventory_asset_flag%TYPE;
1616: l_enable_vmi_flag PO_ASL_ATTRIBUTES.enable_vmi_flag%TYPE;
1617: l_last_billing_date PO_ASL_ATTRIBUTES.last_billing_date%TYPE;
1618: l_cons_billing_cycle PO_ASL_ATTRIBUTES.consigned_billing_cycle%TYPE;
1619: --
1620: l_inventory_org_id
1621: FINANCIALS_SYSTEM_PARAMS_ALL.inventory_organization_id%TYPE;

Line 1618: l_cons_billing_cycle PO_ASL_ATTRIBUTES.consigned_billing_cycle%TYPE;

1614: l_msg_count NUMBER;
1615: l_asset_flag MTL_SYSTEM_ITEMS_B.inventory_asset_flag%TYPE;
1616: l_enable_vmi_flag PO_ASL_ATTRIBUTES.enable_vmi_flag%TYPE;
1617: l_last_billing_date PO_ASL_ATTRIBUTES.last_billing_date%TYPE;
1618: l_cons_billing_cycle PO_ASL_ATTRIBUTES.consigned_billing_cycle%TYPE;
1619: --
1620: l_inventory_org_id
1621: FINANCIALS_SYSTEM_PARAMS_ALL.inventory_organization_id%TYPE;
1622:

Line 1810: l_enable_vmi_flag po_asl_attributes.enable_vmi_flag%TYPE := NULL;

1806: l_return_status varchar2(1) := NULL;
1807: l_msg_count number := NULL;
1808: l_msg_data varchar2(2000) := NULL;
1809: l_item_inv_asset_flag mtl_system_items_b.inventory_asset_flag%TYPE := 'N';
1810: l_enable_vmi_flag po_asl_attributes.enable_vmi_flag%TYPE := NULL;
1811: l_last_billing_date date := NULL;
1812: l_consigned_billing_cycle number := NULL;
1813: l_module_name CONSTANT VARCHAR2(100) := 'IS_ASL_CONSIGNED_FROM_SUPPLIER';
1814: d_module_base CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base( D_PACKAGE_BASE, l_module_name);