DBA Data[Home] [Help]

APPS.WSM_WIP_LOT_TXN_PVT dependencies on WIP_DISCRETE_JOBS

Line 49: STATUS_TYPE WIP_DISCRETE_JOBS.status_type%type,

45: /* Job header kinda.....*/
46: WIP_ENTITY_ID WSM_SM_STARTING_JOBS.WIP_ENTITY_ID%TYPE,
47: WIP_ENTITY_NAME WSM_SM_STARTING_JOBS.WIP_ENTITY_NAME%TYPE,
48: JOB_TYPE NUMBER,
49: STATUS_TYPE WIP_DISCRETE_JOBS.status_type%type,
50: DESCRIPTION WIP_ENTITIES.DESCRIPTION%type,
51: REPRESENTATIVE_FLAG WSM_SM_STARTING_JOBS.REPRESENTATIVE_FLAG%TYPE,
52: SERIAL_TRACK_FLAG NUMBER, -- ST : Serial Support Project --
53:

Line 55: CLASS_CODE WIP_DISCRETE_JOBS.CLASS_CODE%type,

51: REPRESENTATIVE_FLAG WSM_SM_STARTING_JOBS.REPRESENTATIVE_FLAG%TYPE,
52: SERIAL_TRACK_FLAG NUMBER, -- ST : Serial Support Project --
53:
54: /* Primary info....*/
55: CLASS_CODE WIP_DISCRETE_JOBS.CLASS_CODE%type,
56: DEMAND_CLASS WIP_DISCRETE_JOBS.DEMAND_CLASS%type,
57: ORGANIZATION_CODE org_organization_definitions.ORGANIZATION_CODE%TYPE, /* Entry not in the base table */
58: PRIMARY_ITEM_ID WSM_SM_STARTING_JOBS.PRIMARY_ITEM_ID%TYPE,
59: ITEM_NAME mtl_system_items_b_kfv.concatenated_segments%type,

Line 56: DEMAND_CLASS WIP_DISCRETE_JOBS.DEMAND_CLASS%type,

52: SERIAL_TRACK_FLAG NUMBER, -- ST : Serial Support Project --
53:
54: /* Primary info....*/
55: CLASS_CODE WIP_DISCRETE_JOBS.CLASS_CODE%type,
56: DEMAND_CLASS WIP_DISCRETE_JOBS.DEMAND_CLASS%type,
57: ORGANIZATION_CODE org_organization_definitions.ORGANIZATION_CODE%TYPE, /* Entry not in the base table */
58: PRIMARY_ITEM_ID WSM_SM_STARTING_JOBS.PRIMARY_ITEM_ID%TYPE,
59: ITEM_NAME mtl_system_items_b_kfv.concatenated_segments%type,
60: ORGANIZATION_ID WSM_SM_STARTING_JOBS.ORGANIZATION_ID%TYPE,

Line 83: ALTERNATE_BOM_DESIGNATOR WIP_DISCRETE_JOBS.ALTERNATE_BOM_DESIGNATOR%TYPE,

79: BOM_REFERENCE_ID WSM_SM_STARTING_JOBS.BOM_REFERENCE_ID%TYPE,
80: COMMON_BILL_SEQUENCE_ID WSM_SM_STARTING_JOBS.BILL_SEQUENCE_ID%TYPE,
81: BOM_REVISION WSM_SM_STARTING_JOBS.BOM_REVISION%TYPE,
82: BOM_REVISION_DATE WSM_SM_STARTING_JOBS.BOM_REVISION_DATE%TYPE,
83: ALTERNATE_BOM_DESIGNATOR WIP_DISCRETE_JOBS.ALTERNATE_BOM_DESIGNATOR%TYPE,
84: ALTERNATE_ROUTING_DESIGNATOR WIP_DISCRETE_JOBS.ALTERNATE_ROUTING_DESIGNATOR%TYPE,
85: COMMON_ROUTING_SEQUENCE_ID WSM_SM_STARTING_JOBS.ROUTING_SEQ_ID%TYPE,
86: ROUTING_REVISION WSM_SM_STARTING_JOBS.ROUTING_REVISION%TYPE,
87: ROUTING_REVISION_DATE WSM_SM_STARTING_JOBS.ROUTING_REVISION_DATE%TYPE,

Line 84: ALTERNATE_ROUTING_DESIGNATOR WIP_DISCRETE_JOBS.ALTERNATE_ROUTING_DESIGNATOR%TYPE,

80: COMMON_BILL_SEQUENCE_ID WSM_SM_STARTING_JOBS.BILL_SEQUENCE_ID%TYPE,
81: BOM_REVISION WSM_SM_STARTING_JOBS.BOM_REVISION%TYPE,
82: BOM_REVISION_DATE WSM_SM_STARTING_JOBS.BOM_REVISION_DATE%TYPE,
83: ALTERNATE_BOM_DESIGNATOR WIP_DISCRETE_JOBS.ALTERNATE_BOM_DESIGNATOR%TYPE,
84: ALTERNATE_ROUTING_DESIGNATOR WIP_DISCRETE_JOBS.ALTERNATE_ROUTING_DESIGNATOR%TYPE,
85: COMMON_ROUTING_SEQUENCE_ID WSM_SM_STARTING_JOBS.ROUTING_SEQ_ID%TYPE,
86: ROUTING_REVISION WSM_SM_STARTING_JOBS.ROUTING_REVISION%TYPE,
87: ROUTING_REVISION_DATE WSM_SM_STARTING_JOBS.ROUTING_REVISION_DATE%TYPE,
88:

Line 95: DATE_RELEASED WIP_DISCRETE_JOBS.DATE_RELEASED%TYPE,

91: COMPLETION_LOCATOR_ID WSM_SM_STARTING_JOBS.COMPLETION_LOCATOR_ID%TYPE,
92: COMPLETION_LOCATOR mtl_item_locations_kfv.concatenated_segments%TYPE,
93:
94: /* Dates info... */
95: DATE_RELEASED WIP_DISCRETE_JOBS.DATE_RELEASED%TYPE,
96: SCHEDULED_START_DATE WSM_SM_STARTING_JOBS.SCHEDULED_START_DATE%TYPE,
97: SCHEDULED_COMPLETION_DATE WSM_SM_STARTING_JOBS.SCHEDULED_COMPLETION_DATE%TYPE,
98:
99: /* Parameters.... */

Line 101: KANBAN_CARD_ID WIP_DISCRETE_JOBS.KANBAN_CARD_ID%TYPE,

97: SCHEDULED_COMPLETION_DATE WSM_SM_STARTING_JOBS.SCHEDULED_COMPLETION_DATE%TYPE,
98:
99: /* Parameters.... */
100: COPRODUCTS_SUPPLY WSM_SM_STARTING_JOBS.COPRODUCTS_SUPPLY%TYPE,
101: KANBAN_CARD_ID WIP_DISCRETE_JOBS.KANBAN_CARD_ID%TYPE,
102: WIP_SUPPLY_TYPE WIP_DISCRETE_JOBS.WIP_SUPPLY_TYPE%TYPE,
103: /* add wip_supply type..... */
104:
105: ATTRIBUTE_CATEGORY WSM_SM_STARTING_JOBS.ATTRIBUTE_CATEGORY%TYPE,

Line 102: WIP_SUPPLY_TYPE WIP_DISCRETE_JOBS.WIP_SUPPLY_TYPE%TYPE,

98:
99: /* Parameters.... */
100: COPRODUCTS_SUPPLY WSM_SM_STARTING_JOBS.COPRODUCTS_SUPPLY%TYPE,
101: KANBAN_CARD_ID WIP_DISCRETE_JOBS.KANBAN_CARD_ID%TYPE,
102: WIP_SUPPLY_TYPE WIP_DISCRETE_JOBS.WIP_SUPPLY_TYPE%TYPE,
103: /* add wip_supply type..... */
104:
105: ATTRIBUTE_CATEGORY WSM_SM_STARTING_JOBS.ATTRIBUTE_CATEGORY%TYPE,
106: ATTRIBUTE1 WSM_SM_STARTING_JOBS.ATTRIBUTE1%TYPE,

Line 132: STATUS_TYPE WIP_DISCRETE_JOBS.STATUS_TYPE%TYPE,

128: WIP_ENTITY_NAME WSM_SM_RESULTING_JOBS.WIP_ENTITY_NAME%TYPE,
129: WIP_ENTITY_ID WSM_SM_RESULTING_JOBS.WIP_ENTITY_ID%TYPE,
130: DESCRIPTION WSM_SM_RESULTING_JOBS.DESCRIPTION%TYPE,
131: JOB_TYPE WSM_SM_RESULTING_JOBS.JOB_TYPE%TYPE,
132: STATUS_TYPE WIP_DISCRETE_JOBS.STATUS_TYPE%TYPE,
133: wip_supply_type WIP_DISCRETE_JOBS.wip_supply_type%TYPE,
134:
135: /* Primary details */
136: ORGANIZATION_ID WSM_SM_RESULTING_JOBS.ORGANIZATION_ID%TYPE,

Line 133: wip_supply_type WIP_DISCRETE_JOBS.wip_supply_type%TYPE,

129: WIP_ENTITY_ID WSM_SM_RESULTING_JOBS.WIP_ENTITY_ID%TYPE,
130: DESCRIPTION WSM_SM_RESULTING_JOBS.DESCRIPTION%TYPE,
131: JOB_TYPE WSM_SM_RESULTING_JOBS.JOB_TYPE%TYPE,
132: STATUS_TYPE WIP_DISCRETE_JOBS.STATUS_TYPE%TYPE,
133: wip_supply_type WIP_DISCRETE_JOBS.wip_supply_type%TYPE,
134:
135: /* Primary details */
136: ORGANIZATION_ID WSM_SM_RESULTING_JOBS.ORGANIZATION_ID%TYPE,
137: ORGANIZATION_CODE org_organization_definitions.ORGANIZATION_CODE%TYPE, /* Entry not in the base table */

Line 188: KANBAN_CARD_ID WIP_DISCRETE_JOBS.KANBAN_CARD_ID%TYPE,

184:
185: /* Other parameters */
186: BONUS_ACCT_ID WSM_SM_RESULTING_JOBS.BONUS_ACCT_ID%TYPE,
187: COPRODUCTS_SUPPLY WSM_SM_RESULTING_JOBS.COPRODUCTS_SUPPLY%TYPE,
188: KANBAN_CARD_ID WIP_DISCRETE_JOBS.KANBAN_CARD_ID%TYPE,
189:
190: ATTRIBUTE_CATEGORY WSM_SM_RESULTING_JOBS.ATTRIBUTE_CATEGORY%TYPE,
191: ATTRIBUTE1 WSM_SM_RESULTING_JOBS.ATTRIBUTE1%TYPE,
192: ATTRIBUTE2 WSM_SM_RESULTING_JOBS.ATTRIBUTE2%TYPE,