APPS.WSMPINVL dependencies on WSM_RESULTING_LOTS_INTERFACE

Line 1566: wsm_resulting_lots_interface r

1562: r.revision,
1563: r.last_updated_by,
1564: r.created_by
1565: FROM wsm_lot_split_merges_interface m,
1566: wsm_resulting_lots_interface r
1567: WHERE r.header_id = m.header_id
1568: AND m.header_id = p_header_id;
1569:
1570: x_dummy NUMBER;

Line 2434: FROM wsm_resulting_lots_interface crec

2430: WHERE header_id = p_header_id;
2431: BEGIN
2432: SELECT 1
2433: into x_dummy
2434: FROM wsm_resulting_lots_interface crec
2435: WHERE header_id = p_header_id
2436: and (not exists
2437: (
2438: SELECT 1

Line 2546: FROM wsm_resulting_lots_interface

2542: WHERE header_id = p_header_id;
2543:
2544: SELECT count(*)
2545: INTO x_result_ct
2546: FROM wsm_resulting_lots_interface
2547: WHERE header_id = p_header_id;
2548:
2549: -- For Merge Txn, More than one Starting Lot should exist.
2550:

Line 2976: FROM wsm_resulting_lots_interface

2972: lProcLocation := 110;
2973:
2974: SELECT count(*)
2975: INTO x_result_ct
2976: FROM wsm_resulting_lots_interface
2977: WHERE header_id = p_header_id;
2978:
2979: -- Check to see if the is a split txn then there should be only
2980: -- only one starting lot. BBK.

Line 3063: FROM wsm_resulting_lots_interface

3059: lProcLocation := 130;
3060:
3061: SELECT sum(quantity)
3062: into x_result_ct1
3063: FROM wsm_resulting_lots_interface
3064: WHERE header_id = p_header_id;
3065:
3066: -- Check to see if this is a SPLIT txn then
3067: -- StartQty should be GREATER than sumOfResultantQty

Line 3170: FROM wsm_resulting_lots_interface

3166:
3167: l_stmt_num :=20;
3168: SELECT sum(quantity)
3169: INTO x_result
3170: FROM wsm_resulting_lots_interface
3171: WHERE header_id = p_header_id;
3172: l_stmt_num :=21;
3173:
3174:

Line 3196: INSERT INTO wsm_resulting_lots_interface

3192: x_err_msg:= substr(fnd_message.get, 1, 200);
3193: x_err_code := -10;
3194:
3195: l_stmt_num :=30;
3196: INSERT INTO wsm_resulting_lots_interface
3197: (
3198: header_id,
3199: lot_number,
3200: inventory_item_id,

Line 3390: FROM wsm_resulting_lots_interface

3386: revision,
3387: subinventory_code,
3388: locator_id,
3389: quantity
3390: FROM wsm_resulting_lots_interface
3391: WHERE header_id = p_header_id;
3392:
3393: x_reason_id NUMBER;
3394: x_reference VARCHAR2(240);

Line 5393: FROM wsm_resulting_lots_interface r

5389: r.attribute12,
5390: r.attribute13,
5391: r.attribute14,
5392: r.attribute15
5393: FROM wsm_resulting_lots_interface r
5394: , wsm_lot_split_merges_interface h
5395: WHERE h.header_id = p_header_id
5396: and r.header_id = h.header_id;
5397: