eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_MATERIAL_DETAILS_DBL dependencies on GME_MATERIAL_DETAILS

Line 1: PACKAGE BODY gme_material_details_dbl AS

1: PACKAGE BODY gme_material_details_dbl AS
2: /* $Header: GMEVGMDB.pls 120.3 2005/10/04 14:50:58 jsrivast noship $ */
3:
4: /* Global Variables */
5: g_table_name VARCHAR2 (80) DEFAULT 'GME_MATERIAL_DETAILS';

Line 5: g_table_name VARCHAR2 (80) DEFAULT 'GME_MATERIAL_DETAILS';

1: PACKAGE BODY gme_material_details_dbl AS
2: /* $Header: GMEVGMDB.pls 120.3 2005/10/04 14:50:58 jsrivast noship $ */
3:
4: /* Global Variables */
5: g_table_name VARCHAR2 (80) DEFAULT 'GME_MATERIAL_DETAILS';
6: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_MATERIAL_DETAILS_DBL';
7: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
8:
9: /* ===========================================================================

Line 6: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_MATERIAL_DETAILS_DBL';

2: /* $Header: GMEVGMDB.pls 120.3 2005/10/04 14:50:58 jsrivast noship $ */
3:
4: /* Global Variables */
5: g_table_name VARCHAR2 (80) DEFAULT 'GME_MATERIAL_DETAILS';
6: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_MATERIAL_DETAILS_DBL';
7: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
8:
9: /* ===========================================================================
10: | Copyright (c) 2001 Oracle Corporation |

Line 19: | Body of package gme_material_details_dbl |

15: | GMEVGMDB.pls |
16: | |
17: | DESCRIPTION |
18: | |
19: | Body of package gme_material_details_dbl |
20: | |
21: | NOTES |
22: | HISTORY |
23: | |

Line 45: | insert_Row will insert a row in gme_material_details |

41: | TYPE |
42: | Private |
43: | |
44: | USAGE |
45: | insert_Row will insert a row in gme_material_details |
46: | |
47: | |
48: | DESCRIPTION |
49: | insert_Row will insert a row in gme_material_details |

Line 49: | insert_Row will insert a row in gme_material_details |

45: | insert_Row will insert a row in gme_material_details |
46: | |
47: | |
48: | DESCRIPTION |
49: | insert_Row will insert a row in gme_material_details |
50: | |
51: | |
52: | PARAMETERS |
53: | p_material_detail IN gme_material_details%ROWTYPE |

Line 53: | p_material_detail IN gme_material_details%ROWTYPE |

49: | insert_Row will insert a row in gme_material_details |
50: | |
51: | |
52: | PARAMETERS |
53: | p_material_detail IN gme_material_details%ROWTYPE |
54: | x_material_detail IN OUT NOCOPY gme_material_details%ROWTYPE |
55: | RETURNS |
56: | BOOLEAN |
57: | |

Line 54: | x_material_detail IN OUT NOCOPY gme_material_details%ROWTYPE |

50: | |
51: | |
52: | PARAMETERS |
53: | p_material_detail IN gme_material_details%ROWTYPE |
54: | x_material_detail IN OUT NOCOPY gme_material_details%ROWTYPE |
55: | RETURNS |
56: | BOOLEAN |
57: | |
58: | HISTORY |

Line 68: p_material_detail IN gme_material_details%ROWTYPE

64: +==========================================================================+
65: Api end of comments
66: */
67: FUNCTION insert_row (
68: p_material_detail IN gme_material_details%ROWTYPE
69: ,x_material_detail IN OUT NOCOPY gme_material_details%ROWTYPE)
70: RETURN BOOLEAN
71: IS
72: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_ROW';

Line 69: ,x_material_detail IN OUT NOCOPY gme_material_details%ROWTYPE)

65: Api end of comments
66: */
67: FUNCTION insert_row (
68: p_material_detail IN gme_material_details%ROWTYPE
69: ,x_material_detail IN OUT NOCOPY gme_material_details%ROWTYPE)
70: RETURN BOOLEAN
71: IS
72: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_ROW';
73: BEGIN

Line 76: INSERT INTO gme_material_details

72: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_ROW';
73: BEGIN
74: x_material_detail := p_material_detail;
75:
76: INSERT INTO gme_material_details
77: (material_detail_id, batch_id
78: ,formulaline_id
79: ,line_no,
80: --item_id,

Line 256: | fetch_Row will fetch a row in gme_material_details |

252: | TYPE |
253: | Private |
254: | |
255: | USAGE |
256: | fetch_Row will fetch a row in gme_material_details |
257: | |
258: | |
259: | DESCRIPTION |
260: | fetch_row will fetch a row in gme_material_details |

Line 260: | fetch_row will fetch a row in gme_material_details |

256: | fetch_Row will fetch a row in gme_material_details |
257: | |
258: | |
259: | DESCRIPTION |
260: | fetch_row will fetch a row in gme_material_details |
261: | |
262: | |
263: | PARAMETERS |
264: | p_material_detail IN gme_material_details%ROWTYPE |

Line 264: | p_material_detail IN gme_material_details%ROWTYPE |

260: | fetch_row will fetch a row in gme_material_details |
261: | |
262: | |
263: | PARAMETERS |
264: | p_material_detail IN gme_material_details%ROWTYPE |
265: | x_material_detail IN OUT NOCOPY gme_material_details%ROWTYPE |
266: | RETURNS |
267: | BOOLEAN |
268: | |

Line 265: | x_material_detail IN OUT NOCOPY gme_material_details%ROWTYPE |

261: | |
262: | |
263: | PARAMETERS |
264: | p_material_detail IN gme_material_details%ROWTYPE |
265: | x_material_detail IN OUT NOCOPY gme_material_details%ROWTYPE |
266: | RETURNS |
267: | BOOLEAN |
268: | |
269: | HISTORY |

Line 276: p_material_detail IN gme_material_details%ROWTYPE

272: +==========================================================================+
273: Api end of comments
274: */
275: FUNCTION fetch_row (
276: p_material_detail IN gme_material_details%ROWTYPE
277: ,x_material_detail IN OUT NOCOPY gme_material_details%ROWTYPE)
278: RETURN BOOLEAN
279: IS
280: l_api_name CONSTANT VARCHAR2 (30) := 'FETCH_ROW';

Line 277: ,x_material_detail IN OUT NOCOPY gme_material_details%ROWTYPE)

273: Api end of comments
274: */
275: FUNCTION fetch_row (
276: p_material_detail IN gme_material_details%ROWTYPE
277: ,x_material_detail IN OUT NOCOPY gme_material_details%ROWTYPE)
278: RETURN BOOLEAN
279: IS
280: l_api_name CONSTANT VARCHAR2 (30) := 'FETCH_ROW';
281: l_gme_material_details gme_material_details%ROWTYPE;

Line 281: l_gme_material_details gme_material_details%ROWTYPE;

277: ,x_material_detail IN OUT NOCOPY gme_material_details%ROWTYPE)
278: RETURN BOOLEAN
279: IS
280: l_api_name CONSTANT VARCHAR2 (30) := 'FETCH_ROW';
281: l_gme_material_details gme_material_details%ROWTYPE;
282: l_material_detail_id NUMBER;
283: l_batch_id NUMBER;
284: l_line_no NUMBER;
285: l_line_type NUMBER;

Line 370: INTO l_gme_material_details.batch_id

366: ,phantom_line_id
367: ,move_order_line_id
368: ,dtl_um
369: ,dispense_ind
370: INTO l_gme_material_details.batch_id
371: ,l_gme_material_details.material_detail_id
372: ,l_gme_material_details.formulaline_id
373: ,l_gme_material_details.line_no
374: ,

Line 371: ,l_gme_material_details.material_detail_id

367: ,move_order_line_id
368: ,dtl_um
369: ,dispense_ind
370: INTO l_gme_material_details.batch_id
371: ,l_gme_material_details.material_detail_id
372: ,l_gme_material_details.formulaline_id
373: ,l_gme_material_details.line_no
374: ,
375: --l_gme_material_details.item_id,

Line 372: ,l_gme_material_details.formulaline_id

368: ,dtl_um
369: ,dispense_ind
370: INTO l_gme_material_details.batch_id
371: ,l_gme_material_details.material_detail_id
372: ,l_gme_material_details.formulaline_id
373: ,l_gme_material_details.line_no
374: ,
375: --l_gme_material_details.item_id,
376: l_gme_material_details.line_type

Line 373: ,l_gme_material_details.line_no

369: ,dispense_ind
370: INTO l_gme_material_details.batch_id
371: ,l_gme_material_details.material_detail_id
372: ,l_gme_material_details.formulaline_id
373: ,l_gme_material_details.line_no
374: ,
375: --l_gme_material_details.item_id,
376: l_gme_material_details.line_type
377: ,l_gme_material_details.plan_qty

Line 375: --l_gme_material_details.item_id,

371: ,l_gme_material_details.material_detail_id
372: ,l_gme_material_details.formulaline_id
373: ,l_gme_material_details.line_no
374: ,
375: --l_gme_material_details.item_id,
376: l_gme_material_details.line_type
377: ,l_gme_material_details.plan_qty
378: ,
379: --l_gme_material_details.item_um,

Line 376: l_gme_material_details.line_type

372: ,l_gme_material_details.formulaline_id
373: ,l_gme_material_details.line_no
374: ,
375: --l_gme_material_details.item_id,
376: l_gme_material_details.line_type
377: ,l_gme_material_details.plan_qty
378: ,
379: --l_gme_material_details.item_um,
380: l_gme_material_details.item_um2

Line 377: ,l_gme_material_details.plan_qty

373: ,l_gme_material_details.line_no
374: ,
375: --l_gme_material_details.item_id,
376: l_gme_material_details.line_type
377: ,l_gme_material_details.plan_qty
378: ,
379: --l_gme_material_details.item_um,
380: l_gme_material_details.item_um2
381: ,l_gme_material_details.actual_qty

Line 379: --l_gme_material_details.item_um,

375: --l_gme_material_details.item_id,
376: l_gme_material_details.line_type
377: ,l_gme_material_details.plan_qty
378: ,
379: --l_gme_material_details.item_um,
380: l_gme_material_details.item_um2
381: ,l_gme_material_details.actual_qty
382: ,l_gme_material_details.release_type
383: ,l_gme_material_details.scrap_factor

Line 380: l_gme_material_details.item_um2

376: l_gme_material_details.line_type
377: ,l_gme_material_details.plan_qty
378: ,
379: --l_gme_material_details.item_um,
380: l_gme_material_details.item_um2
381: ,l_gme_material_details.actual_qty
382: ,l_gme_material_details.release_type
383: ,l_gme_material_details.scrap_factor
384: ,l_gme_material_details.scale_type

Line 381: ,l_gme_material_details.actual_qty

377: ,l_gme_material_details.plan_qty
378: ,
379: --l_gme_material_details.item_um,
380: l_gme_material_details.item_um2
381: ,l_gme_material_details.actual_qty
382: ,l_gme_material_details.release_type
383: ,l_gme_material_details.scrap_factor
384: ,l_gme_material_details.scale_type
385: ,l_gme_material_details.phantom_type

Line 382: ,l_gme_material_details.release_type

378: ,
379: --l_gme_material_details.item_um,
380: l_gme_material_details.item_um2
381: ,l_gme_material_details.actual_qty
382: ,l_gme_material_details.release_type
383: ,l_gme_material_details.scrap_factor
384: ,l_gme_material_details.scale_type
385: ,l_gme_material_details.phantom_type
386: ,l_gme_material_details.cost_alloc

Line 383: ,l_gme_material_details.scrap_factor

379: --l_gme_material_details.item_um,
380: l_gme_material_details.item_um2
381: ,l_gme_material_details.actual_qty
382: ,l_gme_material_details.release_type
383: ,l_gme_material_details.scrap_factor
384: ,l_gme_material_details.scale_type
385: ,l_gme_material_details.phantom_type
386: ,l_gme_material_details.cost_alloc
387: ,l_gme_material_details.alloc_ind

Line 384: ,l_gme_material_details.scale_type

380: l_gme_material_details.item_um2
381: ,l_gme_material_details.actual_qty
382: ,l_gme_material_details.release_type
383: ,l_gme_material_details.scrap_factor
384: ,l_gme_material_details.scale_type
385: ,l_gme_material_details.phantom_type
386: ,l_gme_material_details.cost_alloc
387: ,l_gme_material_details.alloc_ind
388: ,l_gme_material_details.COST

Line 385: ,l_gme_material_details.phantom_type

381: ,l_gme_material_details.actual_qty
382: ,l_gme_material_details.release_type
383: ,l_gme_material_details.scrap_factor
384: ,l_gme_material_details.scale_type
385: ,l_gme_material_details.phantom_type
386: ,l_gme_material_details.cost_alloc
387: ,l_gme_material_details.alloc_ind
388: ,l_gme_material_details.COST
389: ,l_gme_material_details.text_code

Line 386: ,l_gme_material_details.cost_alloc

382: ,l_gme_material_details.release_type
383: ,l_gme_material_details.scrap_factor
384: ,l_gme_material_details.scale_type
385: ,l_gme_material_details.phantom_type
386: ,l_gme_material_details.cost_alloc
387: ,l_gme_material_details.alloc_ind
388: ,l_gme_material_details.COST
389: ,l_gme_material_details.text_code
390: ,l_gme_material_details.phantom_id

Line 387: ,l_gme_material_details.alloc_ind

383: ,l_gme_material_details.scrap_factor
384: ,l_gme_material_details.scale_type
385: ,l_gme_material_details.phantom_type
386: ,l_gme_material_details.cost_alloc
387: ,l_gme_material_details.alloc_ind
388: ,l_gme_material_details.COST
389: ,l_gme_material_details.text_code
390: ,l_gme_material_details.phantom_id
391: ,l_gme_material_details.created_by

Line 388: ,l_gme_material_details.COST

384: ,l_gme_material_details.scale_type
385: ,l_gme_material_details.phantom_type
386: ,l_gme_material_details.cost_alloc
387: ,l_gme_material_details.alloc_ind
388: ,l_gme_material_details.COST
389: ,l_gme_material_details.text_code
390: ,l_gme_material_details.phantom_id
391: ,l_gme_material_details.created_by
392: ,l_gme_material_details.creation_date

Line 389: ,l_gme_material_details.text_code

385: ,l_gme_material_details.phantom_type
386: ,l_gme_material_details.cost_alloc
387: ,l_gme_material_details.alloc_ind
388: ,l_gme_material_details.COST
389: ,l_gme_material_details.text_code
390: ,l_gme_material_details.phantom_id
391: ,l_gme_material_details.created_by
392: ,l_gme_material_details.creation_date
393: ,l_gme_material_details.last_updated_by

Line 390: ,l_gme_material_details.phantom_id

386: ,l_gme_material_details.cost_alloc
387: ,l_gme_material_details.alloc_ind
388: ,l_gme_material_details.COST
389: ,l_gme_material_details.text_code
390: ,l_gme_material_details.phantom_id
391: ,l_gme_material_details.created_by
392: ,l_gme_material_details.creation_date
393: ,l_gme_material_details.last_updated_by
394: ,l_gme_material_details.last_update_date

Line 391: ,l_gme_material_details.created_by

387: ,l_gme_material_details.alloc_ind
388: ,l_gme_material_details.COST
389: ,l_gme_material_details.text_code
390: ,l_gme_material_details.phantom_id
391: ,l_gme_material_details.created_by
392: ,l_gme_material_details.creation_date
393: ,l_gme_material_details.last_updated_by
394: ,l_gme_material_details.last_update_date
395: ,l_gme_material_details.attribute1

Line 392: ,l_gme_material_details.creation_date

388: ,l_gme_material_details.COST
389: ,l_gme_material_details.text_code
390: ,l_gme_material_details.phantom_id
391: ,l_gme_material_details.created_by
392: ,l_gme_material_details.creation_date
393: ,l_gme_material_details.last_updated_by
394: ,l_gme_material_details.last_update_date
395: ,l_gme_material_details.attribute1
396: ,l_gme_material_details.attribute2

Line 393: ,l_gme_material_details.last_updated_by

389: ,l_gme_material_details.text_code
390: ,l_gme_material_details.phantom_id
391: ,l_gme_material_details.created_by
392: ,l_gme_material_details.creation_date
393: ,l_gme_material_details.last_updated_by
394: ,l_gme_material_details.last_update_date
395: ,l_gme_material_details.attribute1
396: ,l_gme_material_details.attribute2
397: ,l_gme_material_details.attribute3

Line 394: ,l_gme_material_details.last_update_date

390: ,l_gme_material_details.phantom_id
391: ,l_gme_material_details.created_by
392: ,l_gme_material_details.creation_date
393: ,l_gme_material_details.last_updated_by
394: ,l_gme_material_details.last_update_date
395: ,l_gme_material_details.attribute1
396: ,l_gme_material_details.attribute2
397: ,l_gme_material_details.attribute3
398: ,l_gme_material_details.attribute4

Line 395: ,l_gme_material_details.attribute1

391: ,l_gme_material_details.created_by
392: ,l_gme_material_details.creation_date
393: ,l_gme_material_details.last_updated_by
394: ,l_gme_material_details.last_update_date
395: ,l_gme_material_details.attribute1
396: ,l_gme_material_details.attribute2
397: ,l_gme_material_details.attribute3
398: ,l_gme_material_details.attribute4
399: ,l_gme_material_details.attribute5

Line 396: ,l_gme_material_details.attribute2

392: ,l_gme_material_details.creation_date
393: ,l_gme_material_details.last_updated_by
394: ,l_gme_material_details.last_update_date
395: ,l_gme_material_details.attribute1
396: ,l_gme_material_details.attribute2
397: ,l_gme_material_details.attribute3
398: ,l_gme_material_details.attribute4
399: ,l_gme_material_details.attribute5
400: ,l_gme_material_details.attribute6

Line 397: ,l_gme_material_details.attribute3

393: ,l_gme_material_details.last_updated_by
394: ,l_gme_material_details.last_update_date
395: ,l_gme_material_details.attribute1
396: ,l_gme_material_details.attribute2
397: ,l_gme_material_details.attribute3
398: ,l_gme_material_details.attribute4
399: ,l_gme_material_details.attribute5
400: ,l_gme_material_details.attribute6
401: ,l_gme_material_details.attribute7

Line 398: ,l_gme_material_details.attribute4

394: ,l_gme_material_details.last_update_date
395: ,l_gme_material_details.attribute1
396: ,l_gme_material_details.attribute2
397: ,l_gme_material_details.attribute3
398: ,l_gme_material_details.attribute4
399: ,l_gme_material_details.attribute5
400: ,l_gme_material_details.attribute6
401: ,l_gme_material_details.attribute7
402: ,l_gme_material_details.attribute8

Line 399: ,l_gme_material_details.attribute5

395: ,l_gme_material_details.attribute1
396: ,l_gme_material_details.attribute2
397: ,l_gme_material_details.attribute3
398: ,l_gme_material_details.attribute4
399: ,l_gme_material_details.attribute5
400: ,l_gme_material_details.attribute6
401: ,l_gme_material_details.attribute7
402: ,l_gme_material_details.attribute8
403: ,l_gme_material_details.attribute9

Line 400: ,l_gme_material_details.attribute6

396: ,l_gme_material_details.attribute2
397: ,l_gme_material_details.attribute3
398: ,l_gme_material_details.attribute4
399: ,l_gme_material_details.attribute5
400: ,l_gme_material_details.attribute6
401: ,l_gme_material_details.attribute7
402: ,l_gme_material_details.attribute8
403: ,l_gme_material_details.attribute9
404: ,l_gme_material_details.attribute10

Line 401: ,l_gme_material_details.attribute7

397: ,l_gme_material_details.attribute3
398: ,l_gme_material_details.attribute4
399: ,l_gme_material_details.attribute5
400: ,l_gme_material_details.attribute6
401: ,l_gme_material_details.attribute7
402: ,l_gme_material_details.attribute8
403: ,l_gme_material_details.attribute9
404: ,l_gme_material_details.attribute10
405: ,l_gme_material_details.attribute11

Line 402: ,l_gme_material_details.attribute8

398: ,l_gme_material_details.attribute4
399: ,l_gme_material_details.attribute5
400: ,l_gme_material_details.attribute6
401: ,l_gme_material_details.attribute7
402: ,l_gme_material_details.attribute8
403: ,l_gme_material_details.attribute9
404: ,l_gme_material_details.attribute10
405: ,l_gme_material_details.attribute11
406: ,l_gme_material_details.attribute12

Line 403: ,l_gme_material_details.attribute9

399: ,l_gme_material_details.attribute5
400: ,l_gme_material_details.attribute6
401: ,l_gme_material_details.attribute7
402: ,l_gme_material_details.attribute8
403: ,l_gme_material_details.attribute9
404: ,l_gme_material_details.attribute10
405: ,l_gme_material_details.attribute11
406: ,l_gme_material_details.attribute12
407: ,l_gme_material_details.attribute13

Line 404: ,l_gme_material_details.attribute10

400: ,l_gme_material_details.attribute6
401: ,l_gme_material_details.attribute7
402: ,l_gme_material_details.attribute8
403: ,l_gme_material_details.attribute9
404: ,l_gme_material_details.attribute10
405: ,l_gme_material_details.attribute11
406: ,l_gme_material_details.attribute12
407: ,l_gme_material_details.attribute13
408: ,l_gme_material_details.attribute14

Line 405: ,l_gme_material_details.attribute11

401: ,l_gme_material_details.attribute7
402: ,l_gme_material_details.attribute8
403: ,l_gme_material_details.attribute9
404: ,l_gme_material_details.attribute10
405: ,l_gme_material_details.attribute11
406: ,l_gme_material_details.attribute12
407: ,l_gme_material_details.attribute13
408: ,l_gme_material_details.attribute14
409: ,l_gme_material_details.attribute15

Line 406: ,l_gme_material_details.attribute12

402: ,l_gme_material_details.attribute8
403: ,l_gme_material_details.attribute9
404: ,l_gme_material_details.attribute10
405: ,l_gme_material_details.attribute11
406: ,l_gme_material_details.attribute12
407: ,l_gme_material_details.attribute13
408: ,l_gme_material_details.attribute14
409: ,l_gme_material_details.attribute15
410: ,l_gme_material_details.attribute16

Line 407: ,l_gme_material_details.attribute13

403: ,l_gme_material_details.attribute9
404: ,l_gme_material_details.attribute10
405: ,l_gme_material_details.attribute11
406: ,l_gme_material_details.attribute12
407: ,l_gme_material_details.attribute13
408: ,l_gme_material_details.attribute14
409: ,l_gme_material_details.attribute15
410: ,l_gme_material_details.attribute16
411: ,l_gme_material_details.attribute17

Line 408: ,l_gme_material_details.attribute14

404: ,l_gme_material_details.attribute10
405: ,l_gme_material_details.attribute11
406: ,l_gme_material_details.attribute12
407: ,l_gme_material_details.attribute13
408: ,l_gme_material_details.attribute14
409: ,l_gme_material_details.attribute15
410: ,l_gme_material_details.attribute16
411: ,l_gme_material_details.attribute17
412: ,l_gme_material_details.attribute18

Line 409: ,l_gme_material_details.attribute15

405: ,l_gme_material_details.attribute11
406: ,l_gme_material_details.attribute12
407: ,l_gme_material_details.attribute13
408: ,l_gme_material_details.attribute14
409: ,l_gme_material_details.attribute15
410: ,l_gme_material_details.attribute16
411: ,l_gme_material_details.attribute17
412: ,l_gme_material_details.attribute18
413: ,l_gme_material_details.attribute19

Line 410: ,l_gme_material_details.attribute16

406: ,l_gme_material_details.attribute12
407: ,l_gme_material_details.attribute13
408: ,l_gme_material_details.attribute14
409: ,l_gme_material_details.attribute15
410: ,l_gme_material_details.attribute16
411: ,l_gme_material_details.attribute17
412: ,l_gme_material_details.attribute18
413: ,l_gme_material_details.attribute19
414: ,l_gme_material_details.attribute20

Line 411: ,l_gme_material_details.attribute17

407: ,l_gme_material_details.attribute13
408: ,l_gme_material_details.attribute14
409: ,l_gme_material_details.attribute15
410: ,l_gme_material_details.attribute16
411: ,l_gme_material_details.attribute17
412: ,l_gme_material_details.attribute18
413: ,l_gme_material_details.attribute19
414: ,l_gme_material_details.attribute20
415: ,l_gme_material_details.attribute21

Line 412: ,l_gme_material_details.attribute18

408: ,l_gme_material_details.attribute14
409: ,l_gme_material_details.attribute15
410: ,l_gme_material_details.attribute16
411: ,l_gme_material_details.attribute17
412: ,l_gme_material_details.attribute18
413: ,l_gme_material_details.attribute19
414: ,l_gme_material_details.attribute20
415: ,l_gme_material_details.attribute21
416: ,l_gme_material_details.attribute22

Line 413: ,l_gme_material_details.attribute19

409: ,l_gme_material_details.attribute15
410: ,l_gme_material_details.attribute16
411: ,l_gme_material_details.attribute17
412: ,l_gme_material_details.attribute18
413: ,l_gme_material_details.attribute19
414: ,l_gme_material_details.attribute20
415: ,l_gme_material_details.attribute21
416: ,l_gme_material_details.attribute22
417: ,l_gme_material_details.attribute23

Line 414: ,l_gme_material_details.attribute20

410: ,l_gme_material_details.attribute16
411: ,l_gme_material_details.attribute17
412: ,l_gme_material_details.attribute18
413: ,l_gme_material_details.attribute19
414: ,l_gme_material_details.attribute20
415: ,l_gme_material_details.attribute21
416: ,l_gme_material_details.attribute22
417: ,l_gme_material_details.attribute23
418: ,l_gme_material_details.attribute24

Line 415: ,l_gme_material_details.attribute21

411: ,l_gme_material_details.attribute17
412: ,l_gme_material_details.attribute18
413: ,l_gme_material_details.attribute19
414: ,l_gme_material_details.attribute20
415: ,l_gme_material_details.attribute21
416: ,l_gme_material_details.attribute22
417: ,l_gme_material_details.attribute23
418: ,l_gme_material_details.attribute24
419: ,l_gme_material_details.attribute25

Line 416: ,l_gme_material_details.attribute22

412: ,l_gme_material_details.attribute18
413: ,l_gme_material_details.attribute19
414: ,l_gme_material_details.attribute20
415: ,l_gme_material_details.attribute21
416: ,l_gme_material_details.attribute22
417: ,l_gme_material_details.attribute23
418: ,l_gme_material_details.attribute24
419: ,l_gme_material_details.attribute25
420: ,l_gme_material_details.attribute26

Line 417: ,l_gme_material_details.attribute23

413: ,l_gme_material_details.attribute19
414: ,l_gme_material_details.attribute20
415: ,l_gme_material_details.attribute21
416: ,l_gme_material_details.attribute22
417: ,l_gme_material_details.attribute23
418: ,l_gme_material_details.attribute24
419: ,l_gme_material_details.attribute25
420: ,l_gme_material_details.attribute26
421: ,l_gme_material_details.attribute27

Line 418: ,l_gme_material_details.attribute24

414: ,l_gme_material_details.attribute20
415: ,l_gme_material_details.attribute21
416: ,l_gme_material_details.attribute22
417: ,l_gme_material_details.attribute23
418: ,l_gme_material_details.attribute24
419: ,l_gme_material_details.attribute25
420: ,l_gme_material_details.attribute26
421: ,l_gme_material_details.attribute27
422: ,l_gme_material_details.attribute28

Line 419: ,l_gme_material_details.attribute25

415: ,l_gme_material_details.attribute21
416: ,l_gme_material_details.attribute22
417: ,l_gme_material_details.attribute23
418: ,l_gme_material_details.attribute24
419: ,l_gme_material_details.attribute25
420: ,l_gme_material_details.attribute26
421: ,l_gme_material_details.attribute27
422: ,l_gme_material_details.attribute28
423: ,l_gme_material_details.attribute29

Line 420: ,l_gme_material_details.attribute26

416: ,l_gme_material_details.attribute22
417: ,l_gme_material_details.attribute23
418: ,l_gme_material_details.attribute24
419: ,l_gme_material_details.attribute25
420: ,l_gme_material_details.attribute26
421: ,l_gme_material_details.attribute27
422: ,l_gme_material_details.attribute28
423: ,l_gme_material_details.attribute29
424: ,l_gme_material_details.attribute30

Line 421: ,l_gme_material_details.attribute27

417: ,l_gme_material_details.attribute23
418: ,l_gme_material_details.attribute24
419: ,l_gme_material_details.attribute25
420: ,l_gme_material_details.attribute26
421: ,l_gme_material_details.attribute27
422: ,l_gme_material_details.attribute28
423: ,l_gme_material_details.attribute29
424: ,l_gme_material_details.attribute30
425: ,l_gme_material_details.attribute_category

Line 422: ,l_gme_material_details.attribute28

418: ,l_gme_material_details.attribute24
419: ,l_gme_material_details.attribute25
420: ,l_gme_material_details.attribute26
421: ,l_gme_material_details.attribute27
422: ,l_gme_material_details.attribute28
423: ,l_gme_material_details.attribute29
424: ,l_gme_material_details.attribute30
425: ,l_gme_material_details.attribute_category
426: ,l_gme_material_details.last_update_login

Line 423: ,l_gme_material_details.attribute29

419: ,l_gme_material_details.attribute25
420: ,l_gme_material_details.attribute26
421: ,l_gme_material_details.attribute27
422: ,l_gme_material_details.attribute28
423: ,l_gme_material_details.attribute29
424: ,l_gme_material_details.attribute30
425: ,l_gme_material_details.attribute_category
426: ,l_gme_material_details.last_update_login
427: ,l_gme_material_details.scale_rounding_variance

Line 424: ,l_gme_material_details.attribute30

420: ,l_gme_material_details.attribute26
421: ,l_gme_material_details.attribute27
422: ,l_gme_material_details.attribute28
423: ,l_gme_material_details.attribute29
424: ,l_gme_material_details.attribute30
425: ,l_gme_material_details.attribute_category
426: ,l_gme_material_details.last_update_login
427: ,l_gme_material_details.scale_rounding_variance
428: ,l_gme_material_details.scale_multiple

Line 425: ,l_gme_material_details.attribute_category

421: ,l_gme_material_details.attribute27
422: ,l_gme_material_details.attribute28
423: ,l_gme_material_details.attribute29
424: ,l_gme_material_details.attribute30
425: ,l_gme_material_details.attribute_category
426: ,l_gme_material_details.last_update_login
427: ,l_gme_material_details.scale_rounding_variance
428: ,l_gme_material_details.scale_multiple
429: ,l_gme_material_details.rounding_direction

Line 426: ,l_gme_material_details.last_update_login

422: ,l_gme_material_details.attribute28
423: ,l_gme_material_details.attribute29
424: ,l_gme_material_details.attribute30
425: ,l_gme_material_details.attribute_category
426: ,l_gme_material_details.last_update_login
427: ,l_gme_material_details.scale_rounding_variance
428: ,l_gme_material_details.scale_multiple
429: ,l_gme_material_details.rounding_direction
430: ,l_gme_material_details.contribute_yield_ind

Line 427: ,l_gme_material_details.scale_rounding_variance

423: ,l_gme_material_details.attribute29
424: ,l_gme_material_details.attribute30
425: ,l_gme_material_details.attribute_category
426: ,l_gme_material_details.last_update_login
427: ,l_gme_material_details.scale_rounding_variance
428: ,l_gme_material_details.scale_multiple
429: ,l_gme_material_details.rounding_direction
430: ,l_gme_material_details.contribute_yield_ind
431: ,l_gme_material_details.contribute_step_qty_ind

Line 428: ,l_gme_material_details.scale_multiple

424: ,l_gme_material_details.attribute30
425: ,l_gme_material_details.attribute_category
426: ,l_gme_material_details.last_update_login
427: ,l_gme_material_details.scale_rounding_variance
428: ,l_gme_material_details.scale_multiple
429: ,l_gme_material_details.rounding_direction
430: ,l_gme_material_details.contribute_yield_ind
431: ,l_gme_material_details.contribute_step_qty_ind
432: ,l_gme_material_details.wip_plan_qty

Line 429: ,l_gme_material_details.rounding_direction

425: ,l_gme_material_details.attribute_category
426: ,l_gme_material_details.last_update_login
427: ,l_gme_material_details.scale_rounding_variance
428: ,l_gme_material_details.scale_multiple
429: ,l_gme_material_details.rounding_direction
430: ,l_gme_material_details.contribute_yield_ind
431: ,l_gme_material_details.contribute_step_qty_ind
432: ,l_gme_material_details.wip_plan_qty
433: ,l_gme_material_details.original_qty

Line 430: ,l_gme_material_details.contribute_yield_ind

426: ,l_gme_material_details.last_update_login
427: ,l_gme_material_details.scale_rounding_variance
428: ,l_gme_material_details.scale_multiple
429: ,l_gme_material_details.rounding_direction
430: ,l_gme_material_details.contribute_yield_ind
431: ,l_gme_material_details.contribute_step_qty_ind
432: ,l_gme_material_details.wip_plan_qty
433: ,l_gme_material_details.original_qty
434: ,l_gme_material_details.by_product_type

Line 431: ,l_gme_material_details.contribute_step_qty_ind

427: ,l_gme_material_details.scale_rounding_variance
428: ,l_gme_material_details.scale_multiple
429: ,l_gme_material_details.rounding_direction
430: ,l_gme_material_details.contribute_yield_ind
431: ,l_gme_material_details.contribute_step_qty_ind
432: ,l_gme_material_details.wip_plan_qty
433: ,l_gme_material_details.original_qty
434: ,l_gme_material_details.by_product_type
435: ,l_gme_material_details.organization_id

Line 432: ,l_gme_material_details.wip_plan_qty

428: ,l_gme_material_details.scale_multiple
429: ,l_gme_material_details.rounding_direction
430: ,l_gme_material_details.contribute_yield_ind
431: ,l_gme_material_details.contribute_step_qty_ind
432: ,l_gme_material_details.wip_plan_qty
433: ,l_gme_material_details.original_qty
434: ,l_gme_material_details.by_product_type
435: ,l_gme_material_details.organization_id
436: ,l_gme_material_details.inventory_item_id

Line 433: ,l_gme_material_details.original_qty

429: ,l_gme_material_details.rounding_direction
430: ,l_gme_material_details.contribute_yield_ind
431: ,l_gme_material_details.contribute_step_qty_ind
432: ,l_gme_material_details.wip_plan_qty
433: ,l_gme_material_details.original_qty
434: ,l_gme_material_details.by_product_type
435: ,l_gme_material_details.organization_id
436: ,l_gme_material_details.inventory_item_id
437: ,l_gme_material_details.subinventory

Line 434: ,l_gme_material_details.by_product_type

430: ,l_gme_material_details.contribute_yield_ind
431: ,l_gme_material_details.contribute_step_qty_ind
432: ,l_gme_material_details.wip_plan_qty
433: ,l_gme_material_details.original_qty
434: ,l_gme_material_details.by_product_type
435: ,l_gme_material_details.organization_id
436: ,l_gme_material_details.inventory_item_id
437: ,l_gme_material_details.subinventory
438: ,l_gme_material_details.locator_id

Line 435: ,l_gme_material_details.organization_id

431: ,l_gme_material_details.contribute_step_qty_ind
432: ,l_gme_material_details.wip_plan_qty
433: ,l_gme_material_details.original_qty
434: ,l_gme_material_details.by_product_type
435: ,l_gme_material_details.organization_id
436: ,l_gme_material_details.inventory_item_id
437: ,l_gme_material_details.subinventory
438: ,l_gme_material_details.locator_id
439: ,l_gme_material_details.revision

Line 436: ,l_gme_material_details.inventory_item_id

432: ,l_gme_material_details.wip_plan_qty
433: ,l_gme_material_details.original_qty
434: ,l_gme_material_details.by_product_type
435: ,l_gme_material_details.organization_id
436: ,l_gme_material_details.inventory_item_id
437: ,l_gme_material_details.subinventory
438: ,l_gme_material_details.locator_id
439: ,l_gme_material_details.revision
440: ,l_gme_material_details.backordered_qty

Line 437: ,l_gme_material_details.subinventory

433: ,l_gme_material_details.original_qty
434: ,l_gme_material_details.by_product_type
435: ,l_gme_material_details.organization_id
436: ,l_gme_material_details.inventory_item_id
437: ,l_gme_material_details.subinventory
438: ,l_gme_material_details.locator_id
439: ,l_gme_material_details.revision
440: ,l_gme_material_details.backordered_qty
441: ,l_gme_material_details.original_primary_qty

Line 438: ,l_gme_material_details.locator_id

434: ,l_gme_material_details.by_product_type
435: ,l_gme_material_details.organization_id
436: ,l_gme_material_details.inventory_item_id
437: ,l_gme_material_details.subinventory
438: ,l_gme_material_details.locator_id
439: ,l_gme_material_details.revision
440: ,l_gme_material_details.backordered_qty
441: ,l_gme_material_details.original_primary_qty
442: ,l_gme_material_details.material_requirement_date

Line 439: ,l_gme_material_details.revision

435: ,l_gme_material_details.organization_id
436: ,l_gme_material_details.inventory_item_id
437: ,l_gme_material_details.subinventory
438: ,l_gme_material_details.locator_id
439: ,l_gme_material_details.revision
440: ,l_gme_material_details.backordered_qty
441: ,l_gme_material_details.original_primary_qty
442: ,l_gme_material_details.material_requirement_date
443: ,l_gme_material_details.phantom_line_id

Line 440: ,l_gme_material_details.backordered_qty

436: ,l_gme_material_details.inventory_item_id
437: ,l_gme_material_details.subinventory
438: ,l_gme_material_details.locator_id
439: ,l_gme_material_details.revision
440: ,l_gme_material_details.backordered_qty
441: ,l_gme_material_details.original_primary_qty
442: ,l_gme_material_details.material_requirement_date
443: ,l_gme_material_details.phantom_line_id
444: ,l_gme_material_details.move_order_line_id

Line 441: ,l_gme_material_details.original_primary_qty

437: ,l_gme_material_details.subinventory
438: ,l_gme_material_details.locator_id
439: ,l_gme_material_details.revision
440: ,l_gme_material_details.backordered_qty
441: ,l_gme_material_details.original_primary_qty
442: ,l_gme_material_details.material_requirement_date
443: ,l_gme_material_details.phantom_line_id
444: ,l_gme_material_details.move_order_line_id
445: ,l_gme_material_details.dtl_um

Line 442: ,l_gme_material_details.material_requirement_date

438: ,l_gme_material_details.locator_id
439: ,l_gme_material_details.revision
440: ,l_gme_material_details.backordered_qty
441: ,l_gme_material_details.original_primary_qty
442: ,l_gme_material_details.material_requirement_date
443: ,l_gme_material_details.phantom_line_id
444: ,l_gme_material_details.move_order_line_id
445: ,l_gme_material_details.dtl_um
446: ,l_gme_material_details.dispense_ind

Line 443: ,l_gme_material_details.phantom_line_id

439: ,l_gme_material_details.revision
440: ,l_gme_material_details.backordered_qty
441: ,l_gme_material_details.original_primary_qty
442: ,l_gme_material_details.material_requirement_date
443: ,l_gme_material_details.phantom_line_id
444: ,l_gme_material_details.move_order_line_id
445: ,l_gme_material_details.dtl_um
446: ,l_gme_material_details.dispense_ind
447: FROM gme_material_details

Line 444: ,l_gme_material_details.move_order_line_id

440: ,l_gme_material_details.backordered_qty
441: ,l_gme_material_details.original_primary_qty
442: ,l_gme_material_details.material_requirement_date
443: ,l_gme_material_details.phantom_line_id
444: ,l_gme_material_details.move_order_line_id
445: ,l_gme_material_details.dtl_um
446: ,l_gme_material_details.dispense_ind
447: FROM gme_material_details
448: WHERE material_detail_id = l_material_detail_id;

Line 445: ,l_gme_material_details.dtl_um

441: ,l_gme_material_details.original_primary_qty
442: ,l_gme_material_details.material_requirement_date
443: ,l_gme_material_details.phantom_line_id
444: ,l_gme_material_details.move_order_line_id
445: ,l_gme_material_details.dtl_um
446: ,l_gme_material_details.dispense_ind
447: FROM gme_material_details
448: WHERE material_detail_id = l_material_detail_id;
449: ELSIF (l_batch_id IS NOT NULL)

Line 446: ,l_gme_material_details.dispense_ind

442: ,l_gme_material_details.material_requirement_date
443: ,l_gme_material_details.phantom_line_id
444: ,l_gme_material_details.move_order_line_id
445: ,l_gme_material_details.dtl_um
446: ,l_gme_material_details.dispense_ind
447: FROM gme_material_details
448: WHERE material_detail_id = l_material_detail_id;
449: ELSIF (l_batch_id IS NOT NULL)
450: AND (l_line_no IS NOT NULL)

Line 447: FROM gme_material_details

443: ,l_gme_material_details.phantom_line_id
444: ,l_gme_material_details.move_order_line_id
445: ,l_gme_material_details.dtl_um
446: ,l_gme_material_details.dispense_ind
447: FROM gme_material_details
448: WHERE material_detail_id = l_material_detail_id;
449: ELSIF (l_batch_id IS NOT NULL)
450: AND (l_line_no IS NOT NULL)
451: AND (l_line_type IS NOT NULL) THEN

Line 529: INTO l_gme_material_details.batch_id

525: ,phantom_line_id
526: ,move_order_line_id
527: ,dtl_um
528: ,dispense_ind
529: INTO l_gme_material_details.batch_id
530: ,l_gme_material_details.material_detail_id
531: ,l_gme_material_details.formulaline_id
532: ,l_gme_material_details.line_no
533: ,

Line 530: ,l_gme_material_details.material_detail_id

526: ,move_order_line_id
527: ,dtl_um
528: ,dispense_ind
529: INTO l_gme_material_details.batch_id
530: ,l_gme_material_details.material_detail_id
531: ,l_gme_material_details.formulaline_id
532: ,l_gme_material_details.line_no
533: ,
534: --l_gme_material_details.item_id,

Line 531: ,l_gme_material_details.formulaline_id

527: ,dtl_um
528: ,dispense_ind
529: INTO l_gme_material_details.batch_id
530: ,l_gme_material_details.material_detail_id
531: ,l_gme_material_details.formulaline_id
532: ,l_gme_material_details.line_no
533: ,
534: --l_gme_material_details.item_id,
535: l_gme_material_details.line_type

Line 532: ,l_gme_material_details.line_no

528: ,dispense_ind
529: INTO l_gme_material_details.batch_id
530: ,l_gme_material_details.material_detail_id
531: ,l_gme_material_details.formulaline_id
532: ,l_gme_material_details.line_no
533: ,
534: --l_gme_material_details.item_id,
535: l_gme_material_details.line_type
536: ,l_gme_material_details.plan_qty

Line 534: --l_gme_material_details.item_id,

530: ,l_gme_material_details.material_detail_id
531: ,l_gme_material_details.formulaline_id
532: ,l_gme_material_details.line_no
533: ,
534: --l_gme_material_details.item_id,
535: l_gme_material_details.line_type
536: ,l_gme_material_details.plan_qty
537: ,
538: --l_gme_material_details.item_um,

Line 535: l_gme_material_details.line_type

531: ,l_gme_material_details.formulaline_id
532: ,l_gme_material_details.line_no
533: ,
534: --l_gme_material_details.item_id,
535: l_gme_material_details.line_type
536: ,l_gme_material_details.plan_qty
537: ,
538: --l_gme_material_details.item_um,
539: l_gme_material_details.item_um2

Line 536: ,l_gme_material_details.plan_qty

532: ,l_gme_material_details.line_no
533: ,
534: --l_gme_material_details.item_id,
535: l_gme_material_details.line_type
536: ,l_gme_material_details.plan_qty
537: ,
538: --l_gme_material_details.item_um,
539: l_gme_material_details.item_um2
540: ,l_gme_material_details.actual_qty

Line 538: --l_gme_material_details.item_um,

534: --l_gme_material_details.item_id,
535: l_gme_material_details.line_type
536: ,l_gme_material_details.plan_qty
537: ,
538: --l_gme_material_details.item_um,
539: l_gme_material_details.item_um2
540: ,l_gme_material_details.actual_qty
541: ,l_gme_material_details.release_type
542: ,l_gme_material_details.scrap_factor

Line 539: l_gme_material_details.item_um2

535: l_gme_material_details.line_type
536: ,l_gme_material_details.plan_qty
537: ,
538: --l_gme_material_details.item_um,
539: l_gme_material_details.item_um2
540: ,l_gme_material_details.actual_qty
541: ,l_gme_material_details.release_type
542: ,l_gme_material_details.scrap_factor
543: ,l_gme_material_details.scale_type

Line 540: ,l_gme_material_details.actual_qty

536: ,l_gme_material_details.plan_qty
537: ,
538: --l_gme_material_details.item_um,
539: l_gme_material_details.item_um2
540: ,l_gme_material_details.actual_qty
541: ,l_gme_material_details.release_type
542: ,l_gme_material_details.scrap_factor
543: ,l_gme_material_details.scale_type
544: ,l_gme_material_details.phantom_type

Line 541: ,l_gme_material_details.release_type

537: ,
538: --l_gme_material_details.item_um,
539: l_gme_material_details.item_um2
540: ,l_gme_material_details.actual_qty
541: ,l_gme_material_details.release_type
542: ,l_gme_material_details.scrap_factor
543: ,l_gme_material_details.scale_type
544: ,l_gme_material_details.phantom_type
545: ,l_gme_material_details.cost_alloc

Line 542: ,l_gme_material_details.scrap_factor

538: --l_gme_material_details.item_um,
539: l_gme_material_details.item_um2
540: ,l_gme_material_details.actual_qty
541: ,l_gme_material_details.release_type
542: ,l_gme_material_details.scrap_factor
543: ,l_gme_material_details.scale_type
544: ,l_gme_material_details.phantom_type
545: ,l_gme_material_details.cost_alloc
546: ,l_gme_material_details.alloc_ind

Line 543: ,l_gme_material_details.scale_type

539: l_gme_material_details.item_um2
540: ,l_gme_material_details.actual_qty
541: ,l_gme_material_details.release_type
542: ,l_gme_material_details.scrap_factor
543: ,l_gme_material_details.scale_type
544: ,l_gme_material_details.phantom_type
545: ,l_gme_material_details.cost_alloc
546: ,l_gme_material_details.alloc_ind
547: ,l_gme_material_details.COST

Line 544: ,l_gme_material_details.phantom_type

540: ,l_gme_material_details.actual_qty
541: ,l_gme_material_details.release_type
542: ,l_gme_material_details.scrap_factor
543: ,l_gme_material_details.scale_type
544: ,l_gme_material_details.phantom_type
545: ,l_gme_material_details.cost_alloc
546: ,l_gme_material_details.alloc_ind
547: ,l_gme_material_details.COST
548: ,l_gme_material_details.text_code

Line 545: ,l_gme_material_details.cost_alloc

541: ,l_gme_material_details.release_type
542: ,l_gme_material_details.scrap_factor
543: ,l_gme_material_details.scale_type
544: ,l_gme_material_details.phantom_type
545: ,l_gme_material_details.cost_alloc
546: ,l_gme_material_details.alloc_ind
547: ,l_gme_material_details.COST
548: ,l_gme_material_details.text_code
549: ,l_gme_material_details.phantom_id

Line 546: ,l_gme_material_details.alloc_ind

542: ,l_gme_material_details.scrap_factor
543: ,l_gme_material_details.scale_type
544: ,l_gme_material_details.phantom_type
545: ,l_gme_material_details.cost_alloc
546: ,l_gme_material_details.alloc_ind
547: ,l_gme_material_details.COST
548: ,l_gme_material_details.text_code
549: ,l_gme_material_details.phantom_id
550: ,l_gme_material_details.created_by

Line 547: ,l_gme_material_details.COST

543: ,l_gme_material_details.scale_type
544: ,l_gme_material_details.phantom_type
545: ,l_gme_material_details.cost_alloc
546: ,l_gme_material_details.alloc_ind
547: ,l_gme_material_details.COST
548: ,l_gme_material_details.text_code
549: ,l_gme_material_details.phantom_id
550: ,l_gme_material_details.created_by
551: ,l_gme_material_details.creation_date

Line 548: ,l_gme_material_details.text_code

544: ,l_gme_material_details.phantom_type
545: ,l_gme_material_details.cost_alloc
546: ,l_gme_material_details.alloc_ind
547: ,l_gme_material_details.COST
548: ,l_gme_material_details.text_code
549: ,l_gme_material_details.phantom_id
550: ,l_gme_material_details.created_by
551: ,l_gme_material_details.creation_date
552: ,l_gme_material_details.last_updated_by

Line 549: ,l_gme_material_details.phantom_id

545: ,l_gme_material_details.cost_alloc
546: ,l_gme_material_details.alloc_ind
547: ,l_gme_material_details.COST
548: ,l_gme_material_details.text_code
549: ,l_gme_material_details.phantom_id
550: ,l_gme_material_details.created_by
551: ,l_gme_material_details.creation_date
552: ,l_gme_material_details.last_updated_by
553: ,l_gme_material_details.last_update_date

Line 550: ,l_gme_material_details.created_by

546: ,l_gme_material_details.alloc_ind
547: ,l_gme_material_details.COST
548: ,l_gme_material_details.text_code
549: ,l_gme_material_details.phantom_id
550: ,l_gme_material_details.created_by
551: ,l_gme_material_details.creation_date
552: ,l_gme_material_details.last_updated_by
553: ,l_gme_material_details.last_update_date
554: ,l_gme_material_details.attribute1

Line 551: ,l_gme_material_details.creation_date

547: ,l_gme_material_details.COST
548: ,l_gme_material_details.text_code
549: ,l_gme_material_details.phantom_id
550: ,l_gme_material_details.created_by
551: ,l_gme_material_details.creation_date
552: ,l_gme_material_details.last_updated_by
553: ,l_gme_material_details.last_update_date
554: ,l_gme_material_details.attribute1
555: ,l_gme_material_details.attribute2

Line 552: ,l_gme_material_details.last_updated_by

548: ,l_gme_material_details.text_code
549: ,l_gme_material_details.phantom_id
550: ,l_gme_material_details.created_by
551: ,l_gme_material_details.creation_date
552: ,l_gme_material_details.last_updated_by
553: ,l_gme_material_details.last_update_date
554: ,l_gme_material_details.attribute1
555: ,l_gme_material_details.attribute2
556: ,l_gme_material_details.attribute3

Line 553: ,l_gme_material_details.last_update_date

549: ,l_gme_material_details.phantom_id
550: ,l_gme_material_details.created_by
551: ,l_gme_material_details.creation_date
552: ,l_gme_material_details.last_updated_by
553: ,l_gme_material_details.last_update_date
554: ,l_gme_material_details.attribute1
555: ,l_gme_material_details.attribute2
556: ,l_gme_material_details.attribute3
557: ,l_gme_material_details.attribute4

Line 554: ,l_gme_material_details.attribute1

550: ,l_gme_material_details.created_by
551: ,l_gme_material_details.creation_date
552: ,l_gme_material_details.last_updated_by
553: ,l_gme_material_details.last_update_date
554: ,l_gme_material_details.attribute1
555: ,l_gme_material_details.attribute2
556: ,l_gme_material_details.attribute3
557: ,l_gme_material_details.attribute4
558: ,l_gme_material_details.attribute5

Line 555: ,l_gme_material_details.attribute2

551: ,l_gme_material_details.creation_date
552: ,l_gme_material_details.last_updated_by
553: ,l_gme_material_details.last_update_date
554: ,l_gme_material_details.attribute1
555: ,l_gme_material_details.attribute2
556: ,l_gme_material_details.attribute3
557: ,l_gme_material_details.attribute4
558: ,l_gme_material_details.attribute5
559: ,l_gme_material_details.attribute6

Line 556: ,l_gme_material_details.attribute3

552: ,l_gme_material_details.last_updated_by
553: ,l_gme_material_details.last_update_date
554: ,l_gme_material_details.attribute1
555: ,l_gme_material_details.attribute2
556: ,l_gme_material_details.attribute3
557: ,l_gme_material_details.attribute4
558: ,l_gme_material_details.attribute5
559: ,l_gme_material_details.attribute6
560: ,l_gme_material_details.attribute7

Line 557: ,l_gme_material_details.attribute4

553: ,l_gme_material_details.last_update_date
554: ,l_gme_material_details.attribute1
555: ,l_gme_material_details.attribute2
556: ,l_gme_material_details.attribute3
557: ,l_gme_material_details.attribute4
558: ,l_gme_material_details.attribute5
559: ,l_gme_material_details.attribute6
560: ,l_gme_material_details.attribute7
561: ,l_gme_material_details.attribute8

Line 558: ,l_gme_material_details.attribute5

554: ,l_gme_material_details.attribute1
555: ,l_gme_material_details.attribute2
556: ,l_gme_material_details.attribute3
557: ,l_gme_material_details.attribute4
558: ,l_gme_material_details.attribute5
559: ,l_gme_material_details.attribute6
560: ,l_gme_material_details.attribute7
561: ,l_gme_material_details.attribute8
562: ,l_gme_material_details.attribute9

Line 559: ,l_gme_material_details.attribute6

555: ,l_gme_material_details.attribute2
556: ,l_gme_material_details.attribute3
557: ,l_gme_material_details.attribute4
558: ,l_gme_material_details.attribute5
559: ,l_gme_material_details.attribute6
560: ,l_gme_material_details.attribute7
561: ,l_gme_material_details.attribute8
562: ,l_gme_material_details.attribute9
563: ,l_gme_material_details.attribute10

Line 560: ,l_gme_material_details.attribute7

556: ,l_gme_material_details.attribute3
557: ,l_gme_material_details.attribute4
558: ,l_gme_material_details.attribute5
559: ,l_gme_material_details.attribute6
560: ,l_gme_material_details.attribute7
561: ,l_gme_material_details.attribute8
562: ,l_gme_material_details.attribute9
563: ,l_gme_material_details.attribute10
564: ,l_gme_material_details.attribute11

Line 561: ,l_gme_material_details.attribute8

557: ,l_gme_material_details.attribute4
558: ,l_gme_material_details.attribute5
559: ,l_gme_material_details.attribute6
560: ,l_gme_material_details.attribute7
561: ,l_gme_material_details.attribute8
562: ,l_gme_material_details.attribute9
563: ,l_gme_material_details.attribute10
564: ,l_gme_material_details.attribute11
565: ,l_gme_material_details.attribute12

Line 562: ,l_gme_material_details.attribute9

558: ,l_gme_material_details.attribute5
559: ,l_gme_material_details.attribute6
560: ,l_gme_material_details.attribute7
561: ,l_gme_material_details.attribute8
562: ,l_gme_material_details.attribute9
563: ,l_gme_material_details.attribute10
564: ,l_gme_material_details.attribute11
565: ,l_gme_material_details.attribute12
566: ,l_gme_material_details.attribute13

Line 563: ,l_gme_material_details.attribute10

559: ,l_gme_material_details.attribute6
560: ,l_gme_material_details.attribute7
561: ,l_gme_material_details.attribute8
562: ,l_gme_material_details.attribute9
563: ,l_gme_material_details.attribute10
564: ,l_gme_material_details.attribute11
565: ,l_gme_material_details.attribute12
566: ,l_gme_material_details.attribute13
567: ,l_gme_material_details.attribute14

Line 564: ,l_gme_material_details.attribute11

560: ,l_gme_material_details.attribute7
561: ,l_gme_material_details.attribute8
562: ,l_gme_material_details.attribute9
563: ,l_gme_material_details.attribute10
564: ,l_gme_material_details.attribute11
565: ,l_gme_material_details.attribute12
566: ,l_gme_material_details.attribute13
567: ,l_gme_material_details.attribute14
568: ,l_gme_material_details.attribute15

Line 565: ,l_gme_material_details.attribute12

561: ,l_gme_material_details.attribute8
562: ,l_gme_material_details.attribute9
563: ,l_gme_material_details.attribute10
564: ,l_gme_material_details.attribute11
565: ,l_gme_material_details.attribute12
566: ,l_gme_material_details.attribute13
567: ,l_gme_material_details.attribute14
568: ,l_gme_material_details.attribute15
569: ,l_gme_material_details.attribute16

Line 566: ,l_gme_material_details.attribute13

562: ,l_gme_material_details.attribute9
563: ,l_gme_material_details.attribute10
564: ,l_gme_material_details.attribute11
565: ,l_gme_material_details.attribute12
566: ,l_gme_material_details.attribute13
567: ,l_gme_material_details.attribute14
568: ,l_gme_material_details.attribute15
569: ,l_gme_material_details.attribute16
570: ,l_gme_material_details.attribute17

Line 567: ,l_gme_material_details.attribute14

563: ,l_gme_material_details.attribute10
564: ,l_gme_material_details.attribute11
565: ,l_gme_material_details.attribute12
566: ,l_gme_material_details.attribute13
567: ,l_gme_material_details.attribute14
568: ,l_gme_material_details.attribute15
569: ,l_gme_material_details.attribute16
570: ,l_gme_material_details.attribute17
571: ,l_gme_material_details.attribute18

Line 568: ,l_gme_material_details.attribute15

564: ,l_gme_material_details.attribute11
565: ,l_gme_material_details.attribute12
566: ,l_gme_material_details.attribute13
567: ,l_gme_material_details.attribute14
568: ,l_gme_material_details.attribute15
569: ,l_gme_material_details.attribute16
570: ,l_gme_material_details.attribute17
571: ,l_gme_material_details.attribute18
572: ,l_gme_material_details.attribute19

Line 569: ,l_gme_material_details.attribute16

565: ,l_gme_material_details.attribute12
566: ,l_gme_material_details.attribute13
567: ,l_gme_material_details.attribute14
568: ,l_gme_material_details.attribute15
569: ,l_gme_material_details.attribute16
570: ,l_gme_material_details.attribute17
571: ,l_gme_material_details.attribute18
572: ,l_gme_material_details.attribute19
573: ,l_gme_material_details.attribute20

Line 570: ,l_gme_material_details.attribute17

566: ,l_gme_material_details.attribute13
567: ,l_gme_material_details.attribute14
568: ,l_gme_material_details.attribute15
569: ,l_gme_material_details.attribute16
570: ,l_gme_material_details.attribute17
571: ,l_gme_material_details.attribute18
572: ,l_gme_material_details.attribute19
573: ,l_gme_material_details.attribute20
574: ,l_gme_material_details.attribute21

Line 571: ,l_gme_material_details.attribute18

567: ,l_gme_material_details.attribute14
568: ,l_gme_material_details.attribute15
569: ,l_gme_material_details.attribute16
570: ,l_gme_material_details.attribute17
571: ,l_gme_material_details.attribute18
572: ,l_gme_material_details.attribute19
573: ,l_gme_material_details.attribute20
574: ,l_gme_material_details.attribute21
575: ,l_gme_material_details.attribute22

Line 572: ,l_gme_material_details.attribute19

568: ,l_gme_material_details.attribute15
569: ,l_gme_material_details.attribute16
570: ,l_gme_material_details.attribute17
571: ,l_gme_material_details.attribute18
572: ,l_gme_material_details.attribute19
573: ,l_gme_material_details.attribute20
574: ,l_gme_material_details.attribute21
575: ,l_gme_material_details.attribute22
576: ,l_gme_material_details.attribute23

Line 573: ,l_gme_material_details.attribute20

569: ,l_gme_material_details.attribute16
570: ,l_gme_material_details.attribute17
571: ,l_gme_material_details.attribute18
572: ,l_gme_material_details.attribute19
573: ,l_gme_material_details.attribute20
574: ,l_gme_material_details.attribute21
575: ,l_gme_material_details.attribute22
576: ,l_gme_material_details.attribute23
577: ,l_gme_material_details.attribute24

Line 574: ,l_gme_material_details.attribute21

570: ,l_gme_material_details.attribute17
571: ,l_gme_material_details.attribute18
572: ,l_gme_material_details.attribute19
573: ,l_gme_material_details.attribute20
574: ,l_gme_material_details.attribute21
575: ,l_gme_material_details.attribute22
576: ,l_gme_material_details.attribute23
577: ,l_gme_material_details.attribute24
578: ,l_gme_material_details.attribute25

Line 575: ,l_gme_material_details.attribute22

571: ,l_gme_material_details.attribute18
572: ,l_gme_material_details.attribute19
573: ,l_gme_material_details.attribute20
574: ,l_gme_material_details.attribute21
575: ,l_gme_material_details.attribute22
576: ,l_gme_material_details.attribute23
577: ,l_gme_material_details.attribute24
578: ,l_gme_material_details.attribute25
579: ,l_gme_material_details.attribute26

Line 576: ,l_gme_material_details.attribute23

572: ,l_gme_material_details.attribute19
573: ,l_gme_material_details.attribute20
574: ,l_gme_material_details.attribute21
575: ,l_gme_material_details.attribute22
576: ,l_gme_material_details.attribute23
577: ,l_gme_material_details.attribute24
578: ,l_gme_material_details.attribute25
579: ,l_gme_material_details.attribute26
580: ,l_gme_material_details.attribute27

Line 577: ,l_gme_material_details.attribute24

573: ,l_gme_material_details.attribute20
574: ,l_gme_material_details.attribute21
575: ,l_gme_material_details.attribute22
576: ,l_gme_material_details.attribute23
577: ,l_gme_material_details.attribute24
578: ,l_gme_material_details.attribute25
579: ,l_gme_material_details.attribute26
580: ,l_gme_material_details.attribute27
581: ,l_gme_material_details.attribute28

Line 578: ,l_gme_material_details.attribute25

574: ,l_gme_material_details.attribute21
575: ,l_gme_material_details.attribute22
576: ,l_gme_material_details.attribute23
577: ,l_gme_material_details.attribute24
578: ,l_gme_material_details.attribute25
579: ,l_gme_material_details.attribute26
580: ,l_gme_material_details.attribute27
581: ,l_gme_material_details.attribute28
582: ,l_gme_material_details.attribute29

Line 579: ,l_gme_material_details.attribute26

575: ,l_gme_material_details.attribute22
576: ,l_gme_material_details.attribute23
577: ,l_gme_material_details.attribute24
578: ,l_gme_material_details.attribute25
579: ,l_gme_material_details.attribute26
580: ,l_gme_material_details.attribute27
581: ,l_gme_material_details.attribute28
582: ,l_gme_material_details.attribute29
583: ,l_gme_material_details.attribute30

Line 580: ,l_gme_material_details.attribute27

576: ,l_gme_material_details.attribute23
577: ,l_gme_material_details.attribute24
578: ,l_gme_material_details.attribute25
579: ,l_gme_material_details.attribute26
580: ,l_gme_material_details.attribute27
581: ,l_gme_material_details.attribute28
582: ,l_gme_material_details.attribute29
583: ,l_gme_material_details.attribute30
584: ,l_gme_material_details.attribute_category

Line 581: ,l_gme_material_details.attribute28

577: ,l_gme_material_details.attribute24
578: ,l_gme_material_details.attribute25
579: ,l_gme_material_details.attribute26
580: ,l_gme_material_details.attribute27
581: ,l_gme_material_details.attribute28
582: ,l_gme_material_details.attribute29
583: ,l_gme_material_details.attribute30
584: ,l_gme_material_details.attribute_category
585: ,l_gme_material_details.last_update_login

Line 582: ,l_gme_material_details.attribute29

578: ,l_gme_material_details.attribute25
579: ,l_gme_material_details.attribute26
580: ,l_gme_material_details.attribute27
581: ,l_gme_material_details.attribute28
582: ,l_gme_material_details.attribute29
583: ,l_gme_material_details.attribute30
584: ,l_gme_material_details.attribute_category
585: ,l_gme_material_details.last_update_login
586: ,l_gme_material_details.scale_rounding_variance

Line 583: ,l_gme_material_details.attribute30

579: ,l_gme_material_details.attribute26
580: ,l_gme_material_details.attribute27
581: ,l_gme_material_details.attribute28
582: ,l_gme_material_details.attribute29
583: ,l_gme_material_details.attribute30
584: ,l_gme_material_details.attribute_category
585: ,l_gme_material_details.last_update_login
586: ,l_gme_material_details.scale_rounding_variance
587: ,l_gme_material_details.scale_multiple

Line 584: ,l_gme_material_details.attribute_category

580: ,l_gme_material_details.attribute27
581: ,l_gme_material_details.attribute28
582: ,l_gme_material_details.attribute29
583: ,l_gme_material_details.attribute30
584: ,l_gme_material_details.attribute_category
585: ,l_gme_material_details.last_update_login
586: ,l_gme_material_details.scale_rounding_variance
587: ,l_gme_material_details.scale_multiple
588: ,l_gme_material_details.rounding_direction

Line 585: ,l_gme_material_details.last_update_login

581: ,l_gme_material_details.attribute28
582: ,l_gme_material_details.attribute29
583: ,l_gme_material_details.attribute30
584: ,l_gme_material_details.attribute_category
585: ,l_gme_material_details.last_update_login
586: ,l_gme_material_details.scale_rounding_variance
587: ,l_gme_material_details.scale_multiple
588: ,l_gme_material_details.rounding_direction
589: ,l_gme_material_details.contribute_yield_ind

Line 586: ,l_gme_material_details.scale_rounding_variance

582: ,l_gme_material_details.attribute29
583: ,l_gme_material_details.attribute30
584: ,l_gme_material_details.attribute_category
585: ,l_gme_material_details.last_update_login
586: ,l_gme_material_details.scale_rounding_variance
587: ,l_gme_material_details.scale_multiple
588: ,l_gme_material_details.rounding_direction
589: ,l_gme_material_details.contribute_yield_ind
590: ,l_gme_material_details.contribute_step_qty_ind

Line 587: ,l_gme_material_details.scale_multiple

583: ,l_gme_material_details.attribute30
584: ,l_gme_material_details.attribute_category
585: ,l_gme_material_details.last_update_login
586: ,l_gme_material_details.scale_rounding_variance
587: ,l_gme_material_details.scale_multiple
588: ,l_gme_material_details.rounding_direction
589: ,l_gme_material_details.contribute_yield_ind
590: ,l_gme_material_details.contribute_step_qty_ind
591: ,l_gme_material_details.wip_plan_qty

Line 588: ,l_gme_material_details.rounding_direction

584: ,l_gme_material_details.attribute_category
585: ,l_gme_material_details.last_update_login
586: ,l_gme_material_details.scale_rounding_variance
587: ,l_gme_material_details.scale_multiple
588: ,l_gme_material_details.rounding_direction
589: ,l_gme_material_details.contribute_yield_ind
590: ,l_gme_material_details.contribute_step_qty_ind
591: ,l_gme_material_details.wip_plan_qty
592: ,l_gme_material_details.original_qty

Line 589: ,l_gme_material_details.contribute_yield_ind

585: ,l_gme_material_details.last_update_login
586: ,l_gme_material_details.scale_rounding_variance
587: ,l_gme_material_details.scale_multiple
588: ,l_gme_material_details.rounding_direction
589: ,l_gme_material_details.contribute_yield_ind
590: ,l_gme_material_details.contribute_step_qty_ind
591: ,l_gme_material_details.wip_plan_qty
592: ,l_gme_material_details.original_qty
593: ,l_gme_material_details.by_product_type

Line 590: ,l_gme_material_details.contribute_step_qty_ind

586: ,l_gme_material_details.scale_rounding_variance
587: ,l_gme_material_details.scale_multiple
588: ,l_gme_material_details.rounding_direction
589: ,l_gme_material_details.contribute_yield_ind
590: ,l_gme_material_details.contribute_step_qty_ind
591: ,l_gme_material_details.wip_plan_qty
592: ,l_gme_material_details.original_qty
593: ,l_gme_material_details.by_product_type
594: ,l_gme_material_details.organization_id

Line 591: ,l_gme_material_details.wip_plan_qty

587: ,l_gme_material_details.scale_multiple
588: ,l_gme_material_details.rounding_direction
589: ,l_gme_material_details.contribute_yield_ind
590: ,l_gme_material_details.contribute_step_qty_ind
591: ,l_gme_material_details.wip_plan_qty
592: ,l_gme_material_details.original_qty
593: ,l_gme_material_details.by_product_type
594: ,l_gme_material_details.organization_id
595: ,l_gme_material_details.inventory_item_id

Line 592: ,l_gme_material_details.original_qty

588: ,l_gme_material_details.rounding_direction
589: ,l_gme_material_details.contribute_yield_ind
590: ,l_gme_material_details.contribute_step_qty_ind
591: ,l_gme_material_details.wip_plan_qty
592: ,l_gme_material_details.original_qty
593: ,l_gme_material_details.by_product_type
594: ,l_gme_material_details.organization_id
595: ,l_gme_material_details.inventory_item_id
596: ,l_gme_material_details.subinventory

Line 593: ,l_gme_material_details.by_product_type

589: ,l_gme_material_details.contribute_yield_ind
590: ,l_gme_material_details.contribute_step_qty_ind
591: ,l_gme_material_details.wip_plan_qty
592: ,l_gme_material_details.original_qty
593: ,l_gme_material_details.by_product_type
594: ,l_gme_material_details.organization_id
595: ,l_gme_material_details.inventory_item_id
596: ,l_gme_material_details.subinventory
597: ,l_gme_material_details.locator_id

Line 594: ,l_gme_material_details.organization_id

590: ,l_gme_material_details.contribute_step_qty_ind
591: ,l_gme_material_details.wip_plan_qty
592: ,l_gme_material_details.original_qty
593: ,l_gme_material_details.by_product_type
594: ,l_gme_material_details.organization_id
595: ,l_gme_material_details.inventory_item_id
596: ,l_gme_material_details.subinventory
597: ,l_gme_material_details.locator_id
598: ,l_gme_material_details.revision

Line 595: ,l_gme_material_details.inventory_item_id

591: ,l_gme_material_details.wip_plan_qty
592: ,l_gme_material_details.original_qty
593: ,l_gme_material_details.by_product_type
594: ,l_gme_material_details.organization_id
595: ,l_gme_material_details.inventory_item_id
596: ,l_gme_material_details.subinventory
597: ,l_gme_material_details.locator_id
598: ,l_gme_material_details.revision
599: ,l_gme_material_details.backordered_qty

Line 596: ,l_gme_material_details.subinventory

592: ,l_gme_material_details.original_qty
593: ,l_gme_material_details.by_product_type
594: ,l_gme_material_details.organization_id
595: ,l_gme_material_details.inventory_item_id
596: ,l_gme_material_details.subinventory
597: ,l_gme_material_details.locator_id
598: ,l_gme_material_details.revision
599: ,l_gme_material_details.backordered_qty
600: ,l_gme_material_details.original_primary_qty

Line 597: ,l_gme_material_details.locator_id

593: ,l_gme_material_details.by_product_type
594: ,l_gme_material_details.organization_id
595: ,l_gme_material_details.inventory_item_id
596: ,l_gme_material_details.subinventory
597: ,l_gme_material_details.locator_id
598: ,l_gme_material_details.revision
599: ,l_gme_material_details.backordered_qty
600: ,l_gme_material_details.original_primary_qty
601: ,l_gme_material_details.material_requirement_date

Line 598: ,l_gme_material_details.revision

594: ,l_gme_material_details.organization_id
595: ,l_gme_material_details.inventory_item_id
596: ,l_gme_material_details.subinventory
597: ,l_gme_material_details.locator_id
598: ,l_gme_material_details.revision
599: ,l_gme_material_details.backordered_qty
600: ,l_gme_material_details.original_primary_qty
601: ,l_gme_material_details.material_requirement_date
602: ,l_gme_material_details.phantom_line_id

Line 599: ,l_gme_material_details.backordered_qty

595: ,l_gme_material_details.inventory_item_id
596: ,l_gme_material_details.subinventory
597: ,l_gme_material_details.locator_id
598: ,l_gme_material_details.revision
599: ,l_gme_material_details.backordered_qty
600: ,l_gme_material_details.original_primary_qty
601: ,l_gme_material_details.material_requirement_date
602: ,l_gme_material_details.phantom_line_id
603: ,l_gme_material_details.move_order_line_id

Line 600: ,l_gme_material_details.original_primary_qty

596: ,l_gme_material_details.subinventory
597: ,l_gme_material_details.locator_id
598: ,l_gme_material_details.revision
599: ,l_gme_material_details.backordered_qty
600: ,l_gme_material_details.original_primary_qty
601: ,l_gme_material_details.material_requirement_date
602: ,l_gme_material_details.phantom_line_id
603: ,l_gme_material_details.move_order_line_id
604: ,l_gme_material_details.dtl_um

Line 601: ,l_gme_material_details.material_requirement_date

597: ,l_gme_material_details.locator_id
598: ,l_gme_material_details.revision
599: ,l_gme_material_details.backordered_qty
600: ,l_gme_material_details.original_primary_qty
601: ,l_gme_material_details.material_requirement_date
602: ,l_gme_material_details.phantom_line_id
603: ,l_gme_material_details.move_order_line_id
604: ,l_gme_material_details.dtl_um
605: ,l_gme_material_details.dispense_ind

Line 602: ,l_gme_material_details.phantom_line_id

598: ,l_gme_material_details.revision
599: ,l_gme_material_details.backordered_qty
600: ,l_gme_material_details.original_primary_qty
601: ,l_gme_material_details.material_requirement_date
602: ,l_gme_material_details.phantom_line_id
603: ,l_gme_material_details.move_order_line_id
604: ,l_gme_material_details.dtl_um
605: ,l_gme_material_details.dispense_ind
606:

Line 603: ,l_gme_material_details.move_order_line_id

599: ,l_gme_material_details.backordered_qty
600: ,l_gme_material_details.original_primary_qty
601: ,l_gme_material_details.material_requirement_date
602: ,l_gme_material_details.phantom_line_id
603: ,l_gme_material_details.move_order_line_id
604: ,l_gme_material_details.dtl_um
605: ,l_gme_material_details.dispense_ind
606:
607: FROM gme_material_details

Line 604: ,l_gme_material_details.dtl_um

600: ,l_gme_material_details.original_primary_qty
601: ,l_gme_material_details.material_requirement_date
602: ,l_gme_material_details.phantom_line_id
603: ,l_gme_material_details.move_order_line_id
604: ,l_gme_material_details.dtl_um
605: ,l_gme_material_details.dispense_ind
606:
607: FROM gme_material_details
608: WHERE batch_id = l_batch_id

Line 605: ,l_gme_material_details.dispense_ind

601: ,l_gme_material_details.material_requirement_date
602: ,l_gme_material_details.phantom_line_id
603: ,l_gme_material_details.move_order_line_id
604: ,l_gme_material_details.dtl_um
605: ,l_gme_material_details.dispense_ind
606:
607: FROM gme_material_details
608: WHERE batch_id = l_batch_id
609: AND line_no = l_line_no

Line 607: FROM gme_material_details

603: ,l_gme_material_details.move_order_line_id
604: ,l_gme_material_details.dtl_um
605: ,l_gme_material_details.dispense_ind
606:
607: FROM gme_material_details
608: WHERE batch_id = l_batch_id
609: AND line_no = l_line_no
610: AND line_type = l_line_type;
611: ELSE

Line 619: x_material_detail := l_gme_material_details;

615: RETURN FALSE;
616: END IF;
617:
618: IF (SQL%FOUND) THEN
619: x_material_detail := l_gme_material_details;
620: RETURN TRUE;
621: ELSE
622: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
623: ,'TABLE_NAME'

Line 625: x_material_detail := l_gme_material_details;

621: ELSE
622: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
623: ,'TABLE_NAME'
624: ,g_table_name);
625: x_material_detail := l_gme_material_details;
626: RETURN FALSE;
627: END IF;
628: EXCEPTION
629: WHEN NO_DATA_FOUND THEN

Line 657: | delete_Row will delete a row in gme_material_details |

653: | TYPE |
654: | Private |
655: | |
656: | USAGE |
657: | delete_Row will delete a row in gme_material_details |
658: | |
659: | |
660: | DESCRIPTION |
661: | delete_row will delete a row in gme_material_details |

Line 661: | delete_row will delete a row in gme_material_details |

657: | delete_Row will delete a row in gme_material_details |
658: | |
659: | |
660: | DESCRIPTION |
661: | delete_row will delete a row in gme_material_details |
662: | |
663: | |
664: | PARAMETERS |
665: | p_material_detail IN gme_material_details%ROWTYPE |

Line 665: | p_material_detail IN gme_material_details%ROWTYPE |

661: | delete_row will delete a row in gme_material_details |
662: | |
663: | |
664: | PARAMETERS |
665: | p_material_detail IN gme_material_details%ROWTYPE |
666: | RETURNS |
667: | BOOLEAN |
668: | |
669: | HISTORY |

Line 676: FUNCTION delete_row (p_material_detail IN gme_material_details%ROWTYPE)

672: | Added Error message 'GME_RECORD_CHANGED' |
673: +==========================================================================+
674: Api end of comments
675: */
676: FUNCTION delete_row (p_material_detail IN gme_material_details%ROWTYPE)
677: RETURN BOOLEAN
678: IS
679: l_material_detail_id NUMBER;
680: l_batch_id NUMBER;

Line 696: FROM gme_material_details

692:
693: IF l_material_detail_id IS NOT NULL THEN
694: SELECT 1
695: INTO l_dummy
696: FROM gme_material_details
697: WHERE material_detail_id = l_material_detail_id
698: FOR UPDATE NOWAIT;
699:
700: DELETE FROM gme_material_details

Line 700: DELETE FROM gme_material_details

696: FROM gme_material_details
697: WHERE material_detail_id = l_material_detail_id
698: FOR UPDATE NOWAIT;
699:
700: DELETE FROM gme_material_details
701: WHERE material_detail_id = l_material_detail_id;
702: ELSIF (l_batch_id IS NOT NULL)
703: AND (l_line_no IS NOT NULL)
704: AND (l_line_type IS NOT NULL) THEN

Line 707: FROM gme_material_details

703: AND (l_line_no IS NOT NULL)
704: AND (l_line_type IS NOT NULL) THEN
705: SELECT 1
706: INTO l_dummy
707: FROM gme_material_details
708: WHERE batch_id = l_batch_id
709: AND line_no = l_line_no
710: AND line_type = l_line_type
711: FOR UPDATE NOWAIT;

Line 713: DELETE FROM gme_material_details

709: AND line_no = l_line_no
710: AND line_type = l_line_type
711: FOR UPDATE NOWAIT;
712:
713: DELETE FROM gme_material_details
714: WHERE batch_id = l_batch_id
715: AND line_no = l_line_no
716: AND line_type = l_line_type;
717: ELSE

Line 786: | update_row will update a row in gme_material_details |

782: | TYPE |
783: | Private |
784: | |
785: | USAGE |
786: | update_row will update a row in gme_material_details |
787: | |
788: | |
789: | DESCRIPTION |
790: | update_row will update a row in gme_material_details |

Line 790: | update_row will update a row in gme_material_details |

786: | update_row will update a row in gme_material_details |
787: | |
788: | |
789: | DESCRIPTION |
790: | update_row will update a row in gme_material_details |
791: | |
792: | |
793: | PARAMETERS |
794: | p_material_detail IN gme_material_details%ROWTYPE |

Line 794: | p_material_detail IN gme_material_details%ROWTYPE |

790: | update_row will update a row in gme_material_details |
791: | |
792: | |
793: | PARAMETERS |
794: | p_material_detail IN gme_material_details%ROWTYPE |
795: | RETURNS |
796: | BOOLEAN | |
797: | HISTORY |
798: | 12-FEB-2001 fabdi Created

Line 806: FUNCTION update_row (p_material_detail IN gme_material_details%ROWTYPE)

802: | |
803: +==========================================================================+
804: Api end of comments
805: */
806: FUNCTION update_row (p_material_detail IN gme_material_details%ROWTYPE)
807: RETURN BOOLEAN
808: IS
809: l_material_detail_id NUMBER;
810: l_batch_id NUMBER;

Line 826: FROM gme_material_details

822:
823: IF l_material_detail_id IS NOT NULL THEN
824: SELECT 1
825: INTO l_dummy
826: FROM gme_material_details
827: WHERE material_detail_id = l_material_detail_id
828: FOR UPDATE NOWAIT;
829:
830: UPDATE gme_material_details

Line 830: UPDATE gme_material_details

826: FROM gme_material_details
827: WHERE material_detail_id = l_material_detail_id
828: FOR UPDATE NOWAIT;
829:
830: UPDATE gme_material_details
831: SET formulaline_id = p_material_detail.formulaline_id
832: ,line_no = p_material_detail.line_no
833: ,
834: --item_id = p_material_detail.item_id,

Line 914: FROM gme_material_details

910: AND (l_line_no IS NOT NULL)
911: AND (l_line_type IS NOT NULL) THEN
912: SELECT 1
913: INTO l_dummy
914: FROM gme_material_details
915: WHERE batch_id = l_batch_id
916: AND line_no = l_line_no
917: AND line_type = l_line_type
918: FOR UPDATE NOWAIT;

Line 920: UPDATE gme_material_details

916: AND line_no = l_line_no
917: AND line_type = l_line_type
918: FOR UPDATE NOWAIT;
919:
920: UPDATE gme_material_details
921: SET formulaline_id = p_material_detail.formulaline_id
922: ,line_no = p_material_detail.line_no
923: ,line_type = p_material_detail.line_type
924: ,plan_qty = p_material_detail.plan_qty

Line 1064: | fetch_tab will fetch a tab in gme_material_details |

1060: | TYPE |
1061: | Private |
1062: | |
1063: | USAGE |
1064: | fetch_tab will fetch a tab in gme_material_details |
1065: | |
1066: | |
1067: | DESCRIPTION |
1068: | fetch_tab will fetch a tab in gme_material_details |

Line 1068: | fetch_tab will fetch a tab in gme_material_details |

1064: | fetch_tab will fetch a tab in gme_material_details |
1065: | |
1066: | |
1067: | DESCRIPTION |
1068: | fetch_tab will fetch a tab in gme_material_details |
1069: | |
1070: | |
1071: | PARAMETERS |
1072: | p_material_detail IN gme_material_details%ROWTYPE |

Line 1072: | p_material_detail IN gme_material_details%ROWTYPE |

1068: | fetch_tab will fetch a tab in gme_material_details |
1069: | |
1070: | |
1071: | PARAMETERS |
1072: | p_material_detail IN gme_material_details%ROWTYPE |
1073: | x_material_detail IN OUT NOCOPY GME_API_GRP.material_details_tab |
1074: | |
1075: | RETURNS |
1076: | BOOLEAN |

Line 1084: p_material_detail IN gme_material_details%ROWTYPE

1080: | |
1081: +==========================================================================+
1082: */
1083: FUNCTION fetch_tab (
1084: p_material_detail IN gme_material_details%ROWTYPE
1085: ,x_material_detail IN OUT NOCOPY gme_common_pvt.material_details_tab)
1086: RETURN BOOLEAN
1087: IS
1088: i NUMBER := 0;

Line 1094: FROM gme_material_details

1090:
1091: CURSOR c_material_dtl_0 (l_batch_id IN NUMBER)
1092: IS
1093: SELECT *
1094: FROM gme_material_details
1095: WHERE batch_id = l_batch_id;
1096:
1097: CURSOR c_material_dtl_1 (l_mat_dtl_id IN NUMBER)
1098: IS

Line 1100: FROM gme_material_details

1096:
1097: CURSOR c_material_dtl_1 (l_mat_dtl_id IN NUMBER)
1098: IS
1099: SELECT *
1100: FROM gme_material_details
1101: WHERE material_detail_id = l_mat_dtl_id;
1102:
1103: CURSOR c_material_dtl_2 (
1104: l_batch_id IN NUMBER

Line 1109: FROM gme_material_details

1105: ,l_line_no IN NUMBER
1106: ,l_line_type IN NUMBER)
1107: IS
1108: SELECT *
1109: FROM gme_material_details
1110: WHERE batch_id = l_batch_id
1111: AND line_no = l_line_no
1112: AND line_type = l_line_type;
1113: BEGIN

Line 1220: END gme_material_details_dbl;

1216:
1217: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
1218: RETURN FALSE;
1219: END fetch_tab;
1220: END gme_material_details_dbl;