APPS.PO_WF_PO_CHARGE_ACC dependencies on MTL_SYSTEM_ITEMS

Line 235: from MTL_SYSTEM_ITEMS

231:
232: if (x_account is NULL) then -- Get expense account from Item Master
233: begin
234: select EXPENSE_ACCOUNT into x_account
235: from MTL_SYSTEM_ITEMS
236: where organization_id = x_dest_org_id
237: and inventory_item_id = x_item_id;
238:
239: exception

Line 396: from mtl_system_items

392: begin
393: x_progress := 'PO_WF_PO_CHARGE_ACC.check_inv_item_type: 01';
394:
395: select inventory_asset_flag into x_asset_item_flag
396: from mtl_system_items
397: where organization_id = x_dest_org_id
398: and inventory_item_id = x_item_id;
399:
400: /* Start DEBUG

Line 547: from MTL_SYSTEM_ITEMS

543: ELSE
544: begin
545:
546: select EXPENSE_ACCOUNT into x_expense_acc
547: from MTL_SYSTEM_ITEMS
548: where organization_id = x_dest_org_id
549: and inventory_item_id = x_item_id;
550:
551: /*Bug 1319679

Line 1506: is_shopfloor_enabled_item MTL_SYSTEM_ITEMS.outside_operation_flag%TYPE;

1502: ---------------------------------------------------------------------------
1503: FUNCTION is_shopfloor_enabled_item(p_item_id IN NUMBER,
1504: p_inv_org_id IN NUMBER) RETURN BOOLEAN
1505: IS
1506: is_shopfloor_enabled_item MTL_SYSTEM_ITEMS.outside_operation_flag%TYPE;
1507: BEGIN
1508: --SQL WHAT: Get the outside_operation_flag for a given item
1509: --SQL WHY: To find out if the item is Shopfloor enabled.
1510: SELECT outside_operation_flag -- it is a NOT NULL column

Line 1512: FROM MTL_SYSTEM_ITEMS

1508: --SQL WHAT: Get the outside_operation_flag for a given item
1509: --SQL WHY: To find out if the item is Shopfloor enabled.
1510: SELECT outside_operation_flag -- it is a NOT NULL column
1511: INTO is_shopfloor_enabled_item
1512: FROM MTL_SYSTEM_ITEMS
1513: WHERE inventory_item_id = p_item_id AND
1514: organization_id = p_inv_org_id;
1515:
1516: IF (is_shopfloor_enabled_item = 'Y') THEN

Line 1608: FROM MTL_SYSTEM_ITEMS

1604: -- Inventory Org for a Start OU for a given Transaction Flow.
1605: --SQL WHY: To default this as the PO Expense Account for SPS case
1606: SELECT expense_account
1607: INTO l_item_expense_account_id
1608: FROM MTL_SYSTEM_ITEMS
1609: WHERE organization_id = p_inv_org_id AND
1610: inventory_item_id = p_item_id;
1611:
1612: RETURN l_item_expense_account_id;