APPS.INV_STATUS_PKG dependencies on MTL_TRANSACTION_REASONS

Line 1465: FROM MTL_TRANSACTION_REASONS

1461: END IF;
1462: if p_sub_status_id >0 then
1463: SELECT WORKFLOW_NAME
1464: INTO l_workflow_name
1465: FROM MTL_TRANSACTION_REASONS
1466: WHERE REASON_ID = p_sub_reason_id;
1467:
1468: SELECT REASON_NAME
1469: INTO l_reason_name

Line 1470: FROM MTL_TRANSACTION_REASONS

1466: WHERE REASON_ID = p_sub_reason_id;
1467:
1468: SELECT REASON_NAME
1469: INTO l_reason_name
1470: FROM MTL_TRANSACTION_REASONS
1471: WHERE REASON_ID = p_sub_reason_id;
1472:
1473: SELECT status_code
1474: INTO l_status_code

Line 1522: FROM MTL_TRANSACTION_REASONS

1518:
1519: if p_loc_status_id >0 then
1520: SELECT WORKFLOW_NAME
1521: INTO l_workflow_name
1522: FROM MTL_TRANSACTION_REASONS
1523: WHERE REASON_ID = p_loc_reason_id;
1524:
1525: SELECT REASON_NAME
1526: INTO l_reason_name

Line 1527: FROM MTL_TRANSACTION_REASONS

1523: WHERE REASON_ID = p_loc_reason_id;
1524:
1525: SELECT REASON_NAME
1526: INTO l_reason_name
1527: FROM MTL_TRANSACTION_REASONS
1528: WHERE REASON_ID = p_loc_reason_id;
1529:
1530: SELECT status_code
1531: INTO l_status_code

Line 1573: FROM MTL_TRANSACTION_REASONS

1569:
1570: if p_lot_status_id >0 then
1571: SELECT WORKFLOW_NAME
1572: INTO l_workflow_name
1573: FROM MTL_TRANSACTION_REASONS
1574: WHERE REASON_ID = p_lot_reason_id;
1575:
1576: SELECT REASON_NAME
1577: INTO l_reason_name

Line 1578: FROM MTL_TRANSACTION_REASONS

1574: WHERE REASON_ID = p_lot_reason_id;
1575:
1576: SELECT REASON_NAME
1577: INTO l_reason_name
1578: FROM MTL_TRANSACTION_REASONS
1579: WHERE REASON_ID = p_lot_reason_id;
1580:
1581: SELECT status_code
1582: INTO l_status_code

Line 1626: FROM MTL_TRANSACTION_REASONS

1622:
1623: if p_serial_status_id >0 then
1624: SELECT WORKFLOW_NAME
1625: INTO l_workflow_name
1626: FROM MTL_TRANSACTION_REASONS
1627: WHERE REASON_ID = p_serial_reason_id;
1628:
1629: SELECT REASON_NAME
1630: INTO l_reason_name

Line 1631: FROM MTL_TRANSACTION_REASONS

1627: WHERE REASON_ID = p_serial_reason_id;
1628:
1629: SELECT REASON_NAME
1630: INTO l_reason_name
1631: FROM MTL_TRANSACTION_REASONS
1632: WHERE REASON_ID = p_serial_reason_id;
1633:
1634: SELECT status_code
1635: INTO l_status_code

Line 1683: FROM MTL_TRANSACTION_REASONS

1679:
1680: if p_onhand_status_id >0 then
1681: SELECT WORKFLOW_NAME
1682: INTO l_workflow_name
1683: FROM MTL_TRANSACTION_REASONS
1684: WHERE REASON_ID = p_onhand_reason_id;
1685:
1686: SELECT REASON_NAME
1687: INTO l_reason_name

Line 1688: FROM MTL_TRANSACTION_REASONS

1684: WHERE REASON_ID = p_onhand_reason_id;
1685:
1686: SELECT REASON_NAME
1687: INTO l_reason_name
1688: FROM MTL_TRANSACTION_REASONS
1689: WHERE REASON_ID = p_onhand_reason_id;
1690:
1691: SELECT status_code
1692: INTO l_status_code