APPS.INV_STATUS_PKG dependencies on MTL_TRANSACTION_REASONS

Line 843: FROM MTL_TRANSACTION_REASONS

839: END IF;
840: if p_sub_status_id >0 then
841: SELECT WORKFLOW_NAME
842: INTO l_workflow_name
843: FROM MTL_TRANSACTION_REASONS
844: WHERE REASON_ID = p_sub_reason_id;
845:
846: SELECT REASON_NAME
847: INTO l_reason_name

Line 848: FROM MTL_TRANSACTION_REASONS

844: WHERE REASON_ID = p_sub_reason_id;
845:
846: SELECT REASON_NAME
847: INTO l_reason_name
848: FROM MTL_TRANSACTION_REASONS
849: WHERE REASON_ID = p_sub_reason_id;
850:
851: SELECT status_code
852: INTO l_status_code

Line 900: FROM MTL_TRANSACTION_REASONS

896:
897: if p_loc_status_id >0 then
898: SELECT WORKFLOW_NAME
899: INTO l_workflow_name
900: FROM MTL_TRANSACTION_REASONS
901: WHERE REASON_ID = p_loc_reason_id;
902:
903: SELECT REASON_NAME
904: INTO l_reason_name

Line 905: FROM MTL_TRANSACTION_REASONS

901: WHERE REASON_ID = p_loc_reason_id;
902:
903: SELECT REASON_NAME
904: INTO l_reason_name
905: FROM MTL_TRANSACTION_REASONS
906: WHERE REASON_ID = p_loc_reason_id;
907:
908: SELECT status_code
909: INTO l_status_code

Line 951: FROM MTL_TRANSACTION_REASONS

947:
948: if p_lot_status_id >0 then
949: SELECT WORKFLOW_NAME
950: INTO l_workflow_name
951: FROM MTL_TRANSACTION_REASONS
952: WHERE REASON_ID = p_lot_reason_id;
953:
954: SELECT REASON_NAME
955: INTO l_reason_name

Line 956: FROM MTL_TRANSACTION_REASONS

952: WHERE REASON_ID = p_lot_reason_id;
953:
954: SELECT REASON_NAME
955: INTO l_reason_name
956: FROM MTL_TRANSACTION_REASONS
957: WHERE REASON_ID = p_lot_reason_id;
958:
959: SELECT status_code
960: INTO l_status_code

Line 1004: FROM MTL_TRANSACTION_REASONS

1000:
1001: if p_serial_status_id >0 then
1002: SELECT WORKFLOW_NAME
1003: INTO l_workflow_name
1004: FROM MTL_TRANSACTION_REASONS
1005: WHERE REASON_ID = p_serial_reason_id;
1006:
1007: SELECT REASON_NAME
1008: INTO l_reason_name

Line 1009: FROM MTL_TRANSACTION_REASONS

1005: WHERE REASON_ID = p_serial_reason_id;
1006:
1007: SELECT REASON_NAME
1008: INTO l_reason_name
1009: FROM MTL_TRANSACTION_REASONS
1010: WHERE REASON_ID = p_serial_reason_id;
1011:
1012: SELECT status_code
1013: INTO l_status_code

Line 1061: FROM MTL_TRANSACTION_REASONS

1057:
1058: if p_onhand_status_id >0 then
1059: SELECT WORKFLOW_NAME
1060: INTO l_workflow_name
1061: FROM MTL_TRANSACTION_REASONS
1062: WHERE REASON_ID = p_onhand_reason_id;
1063:
1064: SELECT REASON_NAME
1065: INTO l_reason_name

Line 1066: FROM MTL_TRANSACTION_REASONS

1062: WHERE REASON_ID = p_onhand_reason_id;
1063:
1064: SELECT REASON_NAME
1065: INTO l_reason_name
1066: FROM MTL_TRANSACTION_REASONS
1067: WHERE REASON_ID = p_onhand_reason_id;
1068:
1069: SELECT status_code
1070: INTO l_status_code